Report

[smarty84handsome]

I have a table with employee name,employee number,over/short report, Date of Discrepancy. Now i want to create a report in such a way that everytime i input employee number and select date range i should be able to see those discrepancies in that particular date range. Do i need to create a query ? i have created a form but that is meant just for entering data which will be created in table 1. I would appreciate experts help here....

[RayMilhon]

You need to first create a query that returns the data based on those prompts and second create a report to format your results the way you want to see them.

[smarty84handsome]

How do i create query with date range ?

[RayMilhon]

In the Query Editor each column has has a Criteria Section at the bottom There are several line. In the column for the date put in the following "Between [Startdate] and [Enddate]" Now everytime you run the query you will be prompted twice one for each parameter.