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

Resolved · Low Priority · Version Standard

Searching for fields that do not contain numeric values

Richard has attended:
Access Advanced course

by - delegate Richard [6 posts] (2007 Aug 28 Tue, 15:04) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	3	book now	£475	£495
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Searching for fields that do not contain numeric values

by - trainer David gold contributer [428 posts] (2007 Sep 13 Thu, 15:59) Reply

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