Not sure what the easiest way to explain this is, I have a main form which holds information about a job, and then a subform which holds information about items used at that job, along with a final section of detail holding costs about the job. All these forms are linked using a unique job code.
I then generate a report using the above forms, where the user enters the job code and the report is displayed. However I also have an option so that the user can enter an alternate job (say if there are 2 options available, or 2 seperate areas). I think that the easiest way for me to accomplish this is to have a check box on my form that the user ticks if it is an alternate job, I then have a hidden text box on the form that contains the unique job code followed by an A to indicate that its an alternate job. EG: My job code is B1234, and the alternate job code is B1234A. So I would essentially have 2 records, one that holds information on job B1234 and the other that holds information on B1234A.
How can I display both of these on the same query, and eventually report? so that all information relating to job B1234 is shown on one half of the page, and information for job B1234A is on the other half. Not sure if I should post this in the reports forum, or this forum as it relates to both. In the query design would this work if I had all the fields I wanted to use twice, but in the criteria box for the information relating to the alternate job have something that indicates to use the information for the job number followed by an A.
Not sure if the above makes all that much sense with it written out like that. I think it's time to go and play around some more with queries. Thanks for any help.
I then generate a report using the above forms, where the user enters the job code and the report is displayed. However I also have an option so that the user can enter an alternate job (say if there are 2 options available, or 2 seperate areas). I think that the easiest way for me to accomplish this is to have a check box on my form that the user ticks if it is an alternate job, I then have a hidden text box on the form that contains the unique job code followed by an A to indicate that its an alternate job. EG: My job code is B1234, and the alternate job code is B1234A. So I would essentially have 2 records, one that holds information on job B1234 and the other that holds information on B1234A.
How can I display both of these on the same query, and eventually report? so that all information relating to job B1234 is shown on one half of the page, and information for job B1234A is on the other half. Not sure if I should post this in the reports forum, or this forum as it relates to both. In the query design would this work if I had all the fields I wanted to use twice, but in the criteria box for the information relating to the alternate job have something that indicates to use the information for the job number followed by an A.
Not sure if the above makes all that much sense with it written out like that. I think it's time to go and play around some more with queries. Thanks for any help.
