Programming MS Access Reports

[wren17]

Hello Everyone:

I am trying to create a report that links to muliple queries. I can only seem to link to one query per report. However I want a report that has information from more than one query. Is this possible without programming? Also how can I program a text box to display information on a report. I tried and it doesn't give me a .text property for my textbox. I was thinking that I could program an event to run when my Report Opens that would run a procedure to poplulate the textboxes that link to my other queries. Is that possible? I want to say that it is because VB seems to be pretty powerful, but unfortunately I am not used to manipulating for Reports.

Any help would be greatly appreciated.

Thanks,
Matt

 

[Dugantrain]

In the "Properties" of the Report, you can only specify one Recordsource. I'm not 100% certain, but this leads me to believe that you can build a report off of only one table or query (it might be possible if you knew VBA and SQL, but it's definitely impossible using the wizards). Would it be possible for you to write a query that combines your queries and then base your report off of this query?

 

[Mudface]

For your first question, the easiest way would be to combine all the fields you want into a separate query and use that as the record source for the report.

Not sure what you mean with the second one, but you can just type directly into the textbox (in design mode) what you want to see. For example type in =SUM([YourFieldName]) to display a total etc. You can also build these expressions in the textbox's ControlSource property.