reports & queries

rob69

New member
Local time
Yesterday, 17:56
Joined
Jun 27, 2013
Messages
1
Hi

I'm a complete novice when it comes to Access. I need to create a report from a query. That does the following.

I have a form that pulls a query when i select a start date and an end date that gives me a list of dates for

Date Letter sent
Date Letter received

I now need to create a report from the query that tells me how many letters where sent between those dates and how many letters received. How do I go about this? some of the fields will be blank as not all of them will have a date for letter received .

Can anyone help me please?

Thanks:)
 
Docmd.OpenReport "YourReportName",acViewPreview,YourQuery,,AcWindowNormal

Dale
 

Users who are viewing this thread

Back
Top Bottom