Consolidate Multiple Queries into one Output

[ericaindallas]

This sounds like the most simplistic thing to do [well in Excel it is], but I have a large quantity of data that is derived from multiple reports that I would like to combine in one dataset.

I have linked the reports into Tables so they will update each time I save the reports, from there I created seven queries that have two fields in common, 'Date' and 'Name', and each query has additional fields that are different in each that I would like to combine to make one query; what is the best way of accomplishing this task?

This is to track sales activity by account executive by day, so there will be days that an account executive will not make a sales or create a contract, but I still need that date and name to reflected in the dataset output.

Any advice?

Thanks,
Erica

 

[ranman256]

Are you keeping the data in separate tables? You should keep adding data to 1 table.
If you DO have them in many tables, then use an append query to do so.
THEN you can report on anything.

 

[ericaindallas]

The data is in seven separate tables. I now have created a new blank table with the fields I would like from multiple append queries. Then I created another query using the new table, but the data is not aligned. Is there a way to reflect the data where Date and Name is unique for each line, but still populate all the fields?

Table:

Query from Table:

 

[ciapul12]

Hi
Have you tried Append Query?
Dan