Hi,
Can someone please be as kind as to help me complete a task im trying to do at work. For the advanced user i'm sorry if this sounds very basic but your help will be very much appreciated.

I have set up a databse for all our clients, within the database there is a field for when the customer was contacted i.e 20/6/2002. I am trying to set up a query to print a report so that i can run and print/view a report, showing all the customers i have either contacted or havent contacted by date.
E.g if I want to see who i have contacted between 1/6/2002 and 7/06/2002 or havent.

Please can anyone help and sorry if its a very basic topic.

Thank you in advance.

Regards
Hux.

The basics for this are:
Have the user input a beginning and ending date on a form (txtBegDate and txtEndDate), and a command 'Launch Report' button on that form from where you will open and filter your report.

Then from the OnClick event of this command button, you can use for example :
DoCmd.OpenReport "ReportName", "[CustContractedDate] Between " & Me.Controls("txtBegDate ") & " And " & Me.Controls("txtEndDate")

This, assuming that CustContractedDate is the name of the field holding the dates of contractation in the recordsource of your report. See help on OpenReport for further details.

You can also do this through a Parameter Query. Create criteria that initiate input dialog boxes for each of your fields.