Hi.

I have encountered the problem of not knowing whether it is possible to
assign a macro to a query to change the value it looks for. I currently have
a "data entry" sheet that is acting as a day book, and i an "Invoice" sheet
acting as a statment page. I would like to create a query to search for a
specific value that can be changed, and to search for the amount of "jobs,
costs ect." I am finding this very difficult and cannot get it to work.

Any help will be greatly appreciated.

Cheers