Solved

Query criteria

Posted on 2014-07-30
3
173 Views
Last Modified: 2014-07-30
I have a table that has the following values one per record

FD30, FD30S, None, FD60, FD60S, FD120 and FD120S

In a query I want to filter out the records with an "S" on the end leaving

FD30, None, FD60,  and FD120
0
Comment
Question by:DatabaseDek
3 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 40228865
HI

Maybe

SELECT Table1.[Field]
WHERE (((Table1.[Field]) Not Like "*FD##S*" And (Table1.[Field]) Not Like "*FD###S*"));

Regards
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 40228871
select * from tablex
where [field] not like "*S"
0
 

Author Closing Comment

by:DatabaseDek
ID: 40228878
Nice, simple. Thank you
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

912 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

21 Experts available now in Live!

Get 1:1 Help Now