Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to limit displayed data by another field's criteria
Hmm, might need more info on this. The longer version is below. I am trying to generate a report that displays a staffing schedule. I want it to look like a crosstab query, but cannot get that to work as I need to return string data (employee names and hours) rather than numeric values. I...- kjamieson
- Post #4
- Forum: Microsoft: Access Reports
-
How to limit displayed data by another field's criteria
This is likely a newbie question, but I need an expression that will only display a string from a field if another field in the same row generated by the query has a certain numeris value. I'm using Access 97 BTW. Thanks.- kjamieson
- Thread
- Replies: 4
- Forum: Microsoft: Access Reports
