Referencing fields in union query

  • Thread starter Thread starter Winnetou
  • Start date Start date
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)? Is it possible to select a
specific data field in the query so that it can be assigned to a given
text box without using an array?

Thanks for your input.

Mark
 
Hi Mark,

If your union query always returns 2 rows then presumably you're just
getting one row from each part of the query. Dump the query; instead,
you can use DSUM, DAVG and DSTDEV in expressions in the ControlSource
properties of the textboxes.
 
Back
Top