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
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