MS ACCESS help real quick

[Alex]

in a report how can i specify a criteria for a field... like show all entries from the "Semester" table that are equal to "W04"
its easy to do in other parts like queries but i cant find it for reports...

thx

 

[GeekDrew]

Go to report design view, open the report properties, under data type, create a query instead of a table. If there is already a query in place, you can type in [prompt] for the query, and whatever is between the [] will be displayed in a prompt for data (for criteria) every time you run the report.

 

[Alex]

thx thats what i ended up doin