I have a memo field that has details of text and number values. I need a query that searches and can return values between certain values <500 or >1000
Sample below

(1) €2118.10 on 10/8/10, and (2) €739.29 on 14/9/10

Based on the detail above I need to able to do a query that returns a value both <1000 and >1000

Regards

__________________
Brendan Bartley

Unfortunately memo fields are not good for things like this.

How easy it will be to write the VBA code to process the memo field will depend on how constistant the data was added.

To parse the test I would use the VBA command Instr() and Mid().

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015