Inputting info from 3 queries into 1 report

[jalge2]

Hey all. I've got 3 queries that I'm trying to put together into 1 report.

All I want is to be able to add 3 text boxes to a report and make the control source of each text box = the Field in the query.

I tried to use the expression builder but that is giving me a #Name?

Does anyone know of a way that I can do this. Something that should be this simple seems to be really hard. I would guess it's the user .

Thanks for the help.

Jason Alge
Jason.M.Alge@lowes.com

'There are three kinds of people: Those who can count and those who can't'

 

[ZmrAbdulla]

Hi,
Can you make a new query putting all the queries together into one? If it is possible create the report by that query


Zameer Abdulla

http://www.geocities.com/zameerabd/

 

[jalge2]

The only way I think would be to do a Union Query, but I've only seen that done once, and really have no clue how that is performed.

Jason Alge
Jason.M.Alge@lowes.com

'There are three kinds of people: Those who can count and those who can't'

 

[ZmrAbdulla]

Hi,
Union Query? How do you want the data to be displayed?

[b]Query1.Field1    Query2.Field1   Query3.Field1[/b]
Data.........    Data.........   Data........
Data.........    Data.........   Data........
Data.........    Data.........   Data........
Data.........    Data.........   Data........

or

[b]FieldName[/b]
Data...Query1
Data...Query2
Data...Query3
Data...Query1
Data...Query2
Data...Query3

First one from normal query and second from Union query.
Please explain



Zameer Abdulla

http://www.geocities.com/zameerabd/