reports & queries

[rob69]

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

 

[rzw0wr]

Docmd.OpenReport "YourReportName",acViewPreview,YourQuery,,AcWindowNormal

Dale