Help Access Reports

[JavaToPerlNowVB]

I am not sure if I can bring to queries into a one report: I want to user some different columns from different queries.
thanks

 

[GingerR]

Are you asking if you can combine multiple queries and show the resulting dataset on a Report? The answer is Yes.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[JavaToPerlNowVB]

It will be a great help if you could explain how to do it.
thanks

 

[GingerR]

What have you tried so far? All you have to do is write a query and use it as the recordsource in a Report. You are in the FORMS forum, so are you talking about a FORM or a REPORT? That's the first thing we need to be clear on. After that, check the basics of Reports or Forms in MS Access HELP or a text book for how to build one. Let us know how it goes.

g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Pampers]

Hi JavaToPerlNowVB ,
what about making a new query (3th) with the values from the two querys you want to combine?
or, create a new report, go to the record source property of the report, click the ... and that will invoke the query builder, and just build here a new query using the two other ones.
Maybe this helps

Pampers.

You're never too young to learn