Hi. I have created a very simple 2 table, 2 form database for storing 1. client data and 2. other activities for a small not for profit. I need non tech savvy staff around the country to be able to run a monthly report for the previous month for head office stats. Ideally a push button from the switchboard without the need to enter any criteria. I have successfully created a query for each form which pulls data from the last 30 days, and a macro to display this on the switchboard. But not all months have 30 days, and I do not need all fields from the form to be on the monthly report. I then tried to create a filtered field report from the query, and had success designing my report and excluding the fields that were not needed. But the date criteria do not carry through, and the report just pulls out all data in the database. So I need my filtered field report with filtered dates to always pull from the last calendar month. Please help!