one control - two fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have one control on a form list all values from field A of a query, and then all values from field B
 
This is a question that could greatly benefit from you typing a few sample
records and the desired display result in your posting.

--
Duane Hookom
MS Access MVP


EB said:
Is it possible to have one control on a form list all values from field A
Click to expand...
of a query, and then all values from field B
 
For example: The report has a control labeled "Type". The data source is "type1" from Query A. There is another field "type2", in the query. I would like the report to list all values in "type1", then when "type1" filed is empty (all data reported), append the values from "type2" under this same label "Type"
EX
Type1 Type
5

2

Result
Typ
 
You can do this with a union query

SELECT Type1
FROM QueryA
UNION
SELECT Type2
FROM QueryA
WHERE Type2 is not null;

--
Duane Hookom
MS Access MVP


EB said:
For example: The report has a control labeled "Type". The data source is
Click to expand...
"type1" from Query A. There is another field "type2", in the query. I would
like the report to list all values in "type1", then when "type1" filed is
empty (all data reported), append the values from "type2" under this same
label "Type".
 
Back
Top