Sort by Employee?

[AbeA]

Hello,

I have a table that contains a bunch of records, the fields are Employee ID, Task, Date and Vehicle.

All I need to do is create a report that will list all records correlated with only a single employee. For instance, when I open the report, it asks for the Employee ID, you enter it, then the report lists all records that contain that Employee ID, sorted by date.

I also want to be able to create a report that requires entering an employee ID and a single date. My date fields are all MM/DD/YYYY.

 

[Terpsichore]

Create a query with all the fields you need for your report and in the Criteria of the query, under Employe ID type [Enter Employee ID]. Create a report based on that query. When you run the report, a popup will appear asking for Employee ID. Enter the desired ID and hit OK. The report will be generated based on that criteria.

To sort by date, define that in your report under sorting and grouping.