monthly report???

lainey

New member
Local time
Today, 20:56
Joined
Mar 20, 2002
Messages
5
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
smile.gif



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

Users who are viewing this thread

Back
Top Bottom