• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MS ACCESS help real quick

Alex

Diamond Member
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
 
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.
 
Back
Top