Query to store similar fields from two tables in one field

[farey]

Is it possible to make a query that stores similar field data from different two tables into single field. Like, customerName (from both tables to store in same field in query).

 

[speakers_86]

Queries do not 'store' data. They bring data from multiple sources together. It sounds like you miiiiigghttt be asking for a Union query, but I'm not sure. If you have two different tables that both have a field called 'customerName', first of all, read up on normalization. There can be reasons to store the name in two different tables, but not many. If you want to bring those names together, you can use a Select query, where the names will be displayed side-by-side in two columns, or a Union query, where they will all get shoved into one column. I recommend you do some research before you charge ahead.