Less than criteria

[jamespeters01]

I would like to run a criteria in my query that works sort of like the one below, but I would like to bring up all the records less than the number of units I type into the query rather than every record which contains the typed figure.

Like "*" & [number of units ??] & "*"


Any help would be appreciated.


Thanks

 

[Dodgey]

< [number of units ??]

Remember, the LIKE operator is best suited for text fields. It would make no sense to apply this to a numeric field, unless it was postcode or phone number or something like that.

 

[jamespeters01]

Thank you Dodgey,

I realise, that when I press return it thinks I have entered a zero and no records are brought up. Is there a way round this, so that when I just press return it returns all records ??