Selecting data for monthly report

[GrantP]

Hi, I am constructing a database for a friend and need to filter data from a daily log to enable a report to be generated for each months actions. I have created fields of: entry date, month and year with the view of filtering by month and year. How do I perform this task?



Thank you
Grant

[orange]

Use a Date data type. Do NOT store separate Month and Year.
From any Date you can find Day, Month, Year, quarter etc via Access functions.
see http://www.techonthenet.com/access/functions/

[ranman256]

I have a date box...usu start date & end date. Also some quick picks that insert the dates for you.

[GrantP]

Thank you for the advice but as very much a novice, could you explain how I should be organising this.
Thanks again.