how do I mix same fields from two table in field by query

[ab moq]

I have to table in a field a from table 1 I type 3 name and in a field a from
table 2 I type 5 diffrent name
I want to mix them in a 1 field by query
I need to have 8 name in one query

thanks

 

[KARL DEWEY]

I have to table in a field a from table 1
Tables have fields, not have table in a field.
Are you expecting these 8 names to be in one output field or in eight
separate fields?
If you are typing the names in, what is the purpose of the tables in these
actions?

 

[Michel Walsh]

If I understand, you have 3 records in a first table, and 5 records in a
second table, and you want to get a result made of the fields fieldName from
these two tables?


SELECT fieldName FROM table1
UNION ALL
SELECT fieldName FROM table2


would then do the job. You have to type that statement in the SQL view of a
query in the query designer. All caps words are keyword to be typed as I
did, the others words are to be changed by whatever fits your case. The two
"fieldName" can be different, as long as their data type is compatible.



Vanderghast, Access MVP