one control - two fields

[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

 

[Duane Hookom]

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

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

 

[Guest]

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

 

[Duane Hookom]

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

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