Hello folks!
I have a table with daily income, daily customers, and a number as primary kew named "dailyincnr". Now, i was wondering, since it's some time ago i used access. How to make a monthly report based on the selection of a month and year. The date field is of the middel range and contains dd.mm.yyyy
Thanks a lot folks!

Hmmm...ne1? I'm not a newbie or anything...just can't get this one to work, but then again, maybe I am a newbie!? http://www.access-programmers.co.uk/ubb/smile.gif

You can use the Format() function to extract only the year and month from a date:

Select ...
From YourTable
Where Format(SomeDate,"mm/yyyy") = Forms!YourFormName!YourControlName;