Print Report Based on Different Data in the same field 1

[iteach2]

The table has about nine fields:

Change# Status Requester Type Contact# StartTime EndTime

StartDate EndDate.


The Status field will contain the following data(pending, completed, failed) how do i print a report that pulls a entire record based on the status(pending, completed or failed etc----


(Helplessly New to Access)

 

[Databaseguy]

1. Use a paramater in your query

In the field, under criteria, enter [Please enter Status]. If the user types completed, only coleted records will be returned.

-or-

2. Return all of the records. Use the grouping and sorting button and put the status in the report header. Now, All complete records will be in one group, pending ones in the next, etc.... Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[iteach2]

Thank you DataBaseGuy!! This was very helpful and works great!