Referencing fields in an union query

W

Winnetou

I have an union query which returns 2 rows of data:

Exp Tot Avg Std ...
T1 xxx xxx xxx ...
T2 yyy yyy yyy ...

I would like to display the data on a form (in single view mode) as
follows:

Exp T1 T2
Tot xxx yyy
Avg xxx yyy
Std xxx yyy
....

How can I reference a field, say Avg(T2), to display it correctly on
the form? In other words, is it possible to select a specific data
field of the union query so that it can be displayed in a given text
box?

Thanks for your input.

Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top