ok, I can query changes for the month using the expression that David supplied to me;

Between DateSerial(Year(Now()),Month(Now())-1,1) And DateDiff("d",1,DateSerial(Year(Now()),Month(Now()),1))

But I have two Fields call 'Released date' and 'Date of update', so it as to query both fields and print it to the same datasheet view.
I can query one or the other field but not both at the same time.

Can someone till me what i'm doing wrong?

Thanks,
Murley http://www.access-programmers.co.uk/ubb/smile.gif

You want to find any record in which either of those dates is within the past month?

Place the criteria in both fields, but on different lines. It will search both of them. If they must be both in the past month, then put them on the same line (the difference between logical 'OR' and logical 'AND').

HTH,
David R


[This message has been edited by David R (edited 03-20-2002).]

works great!
Thanks David,

Murley http://www.access-programmers.co.uk/ubb/smile.gif