Solved

GL Accounts Create Table Query

Posted on 2013-06-03
2
344 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 500 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
This article will show you how to use shortcut menus in the Access run-time environment.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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 …

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now