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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Choose report/layout according to a record field value
Yes szschech, you got the idea. One sheet for each piece of equipment. There is one table, tblEquipment, that is updated by others and given to me. There is a field in each record that I could use to determine which report to use. The reports are also given to me. I need to use the right report...- ggtektips
- Post #9
- Forum: Microsoft: Access Reports
-
Choose report/layout according to a record field value
Different information is displayed on the three reports but they all have portrait orientation. Each record is data on a piece of equipment. Each record is used to create a one page form that is filled out by a technician as he tests the equipment. So you could imagine that the form details for...- ggtektips
- Post #6
- Forum: Microsoft: Access Reports
-
Choose report/layout according to a record field value
Is this one query that you are using or 3 separate queries and 3 separate reports? The current way is with 3 separate queries and 3 separate reports. This is what I want to eliminate. I can write one query to capture all the records. I want to use that query in one "smart" report. That report...- ggtektips
- Post #4
- Forum: Microsoft: Access Reports
-
Choose report/layout according to a record field value
I have been given the 3 layouts I must use and each is contained in its own report . My job is to create a query that captures the appropriate records. Then depending on a field value in each of those records, I must choose the appropriate layout for that record. I want to automate the "choose...- ggtektips
- Thread
- Replies: 8
- Forum: Microsoft: Access Reports
