my table contains informationon faults of a product for each month and it has an issue date, i want to set up a report to show the number of fault within a particular month but i am not that sure how to set this up

Create a query showing the fields that you need for the report. Then create a new field called Mnth: Format([YourDateField],"mm/yy")

Then make the query a Totals query and group by Mnth.

You can now use this query as the feed for the report

HTH

i have tried doing this but the report still wont show me data between two specific dates, is there any criteria that i need to set the query or report?

Hi

You could create a query to feed the report and in the issue date field criteria type-
Between [Enter start date] and [Enter end date]

This will run the query between the dates you type in.

Col

yes it works!!!!!
thanks
lainey http://www.access-programmers.co.uk/ubb/smile.gif


[This message has been edited by lainey (edited 03-20-2002).]