?
Solved

GL Accounts Create Table Query

Posted on 2013-06-03
2
Medium Priority
?
411 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

777 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