Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

GL Accounts Create Table Query

Posted on 2013-06-03
2
Medium Priority
?
420 Views
Last Modified: 2013-06-03
I have a table that has about 700,000 records and I need to be create a query to create another table with most of the records with the exception of some..

I have a text field that has Accounts and the accounts are as follow:

example of the format is --> 2090-253-00-01.

So I have 4 characters then a '-" another 3 and "-" then 2 and "-" then another 2 and "-"

I did the query as follow: not like "????-253-02-00" or not like "????-253-03-00"

I want to all the records except these that ends in -253-02-00 and -253-03-00 to go to a new table.

when I do that and display the results before I run the query I see that all the records are still being displayed..

Anyone can tell me what I am doing wrong???
0
Comment
Question by:TonyEF
2 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 total points
ID: 39217301
Use AND instead of OR.

Also use # to specifically deal with numeric digits.  ? can be any character.

 not like "####-253-02-00" AND not like "####-253-03-00"
0
 

Author Closing Comment

by:TonyEF
ID: 39217309
Thank you...
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

575 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question