Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

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

Resolved · Low Priority · Version Standard

Reply Tue 28 Aug 2007, 15:04Delegate Richard said...

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

For upcoming training course dates see: Pricing & availability

Reply Thu 13 Sep 2007, 15:59Trainer David said...

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

Access articles

· Protect Sensitive Access Databases With A Password
· Keeping Your Access Database Updated
· Access VBA Handling Errors and Debugging Code
· Reasons to Consider Microsoft Access Training
· How To Successfully Design An Access Database For A Paying Client

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips