Hi all,

I am trying to set up a query that will only bring across a Risk ID field from a table that has been imported from Excel.

The Excel sheet when imported as a table looks like:

Risk Number: Location: Staff:
Risk01 Room01 Jim
- - -
Risk06 Room 09 Jane

All I want is for my Risk Numbers line in the tables to be brought across and any spaces without numbers ignored.

Any help is greatly appreciated as I am unsure of what to place in the Criteria. Look forward to hearing some pointers

Regards

K
:)

For those that viewed the question, many thanks.

I appear to have found an idea that works - Is Not Null

Cheers

K
;)