Query that pulls same data from 5 different queries

[Guest]

I may not be describing this correctly, but here goes.

I have a bunch of data that i am normalizing into a few different columns
via a query. Ex Asset class, Security name, Book valuke, etc.

There are about 5 asset classes and i would like to create a query for each
one that will normalize the data. Right now for each asset class, the data is
in different columns in the text file i import.

Ex. Fixed income book value is in field 12, Equity Book value is in field
14. I

s there a way thru a query, that i can combine the asset classes and book
values of each query into 1 field that can later be summed in excel?

 

[Jeff Boyce]

I believe a UNION query describes one way to do what you are asking about.
Basically, the UNION query gives you a way to combine multiple separate
queries into one. Check Access HELP on this keyword.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff,

I have the following querys, which include all the same fields. Im still
confused, as to how to use the Union Operator. Here are my queries

SCH A
SCH B
SCH BA
SCH D
SCH DA
SCH E