Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access 2003 training - searching fields do not

Forum home » Delegate support and help forum » Microsoft Access Training and help » access 2003 training - Searching for fields that do not contain numeric values

access 2003 training - Searching for fields that do not contain numeric values

ResolvedVersion Standard

Richard has attended:
Access Advanced course

Searching for fields that do not contain numeric values

Hi,

Please can you tell me how I create a query that will show all records that do not have any numeric values in a specific field?

Thanks

Richad

RE: Searching for fields that do not contain numeric values

Hi Richard

This is quite a complex query you are trying to run. I know it is possible to create using VB or VBA, however I am unsure as to whether it is possible to do by just using SQL. If I find a way to do it with SQL I will let you know. You may find it useful to take our Access VBA course in London, as this will give you a good understanding of VBA.

Hope this helps
David

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.