Monthly current Information

[jonamua1971]

Hi All
I have searched the forum and i hasnt found what im looking for.
i would like for my form(datasheetview) to show information only for the current month.
for example ,may it should show may 2008 only.
how can i do that
any help will be greatly appreciated
Thanks

 

[pbaldy]

You could base it on a query that used functions from here to get the current month:

http://www.pacificdb.com.au/MVP/Code/Dates.htm