I'm not sure what you are trying to do, but it seems like you might want a
parameter query. See if this website helps:
http://www.rdg.ac.uk/ITS/info/traini...s/excel/query/


***********
Regards,
Ron


"ivan" wrote:

Hi, im new in this , im doing a query in excel that take info from remedy. i
need to do this everyday and the query must bringe me data from every day .
how can i do it in microsoft query if i put the date i will have to change it
everyday.

in remedy i use $date$ , is any like this?

Thanks in advance