On 4 Nov 2005 18:12:03 -0800,
tomerslider@nana.co.il wrote:
[color=blue]
> i need some code that show me all the expired product that i have in
> every month
> example:
> the date today is 4/11/05 i need that it will show me all the proudct
> that there dates betwenn 1/11/05 and 31/11/05
> and it will be universal code for all the month not a specific month[/color]
For all the records of the current month:
Where Format(YourTable.DateField,"mm/yyyy") = Format(Date(),"mm/yyyy")
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
