is there any way of setting the query up so that if it asks for 'maximum price' and you input it as 20000 it automatically knows that what you mean is £20,000 and searches for that in the table (as its saved as a currency)and brings up those results rather than what it would be if it didnt

Currency fields are numeric fields and do not include currency signs and commas. Searching for 20000 should get the correct answer. If your field is currently designed as text, change it to numeric-currency.

yeah it now works now, very strange, i knocked it off and on again hmmmm just asting up maybe, thanks anyway