Query to run multiple queries

[tlindeman]

Good afternoon,
What I would like to do is run several queries and overwrite a table each time. Each query has the same field names, however, different data. For example, one query is Same Store Sales YTD that has fields: Store number, Average Sales this Year, Average Sales last Year. Then another query is Same Store Sales QTD that has the fields: Store number, Average sales this year, Average Sales last Year. I built a table that has the following fields; YTDStore number, YTD average sales this year, YTD average sales last year, QTDstore number, QTD averagle sales this year, QTD average sales last year. Could you please help. I understand SQL pretty well, so you could post in SQL if that is easier.

Tony

 

[Isskint]

no need for SQL tlindeman, just use the query wizard to create append/update/delete queries as neccesary. Then add a control interface (a form with command buttons) to call these queries.

 

[tlindeman]

O.K.
That makes sense. I was going to use SQl because I wanted to setup a connection in Excel. However, I think can just setup the control interface and have the user run all queries through there.

Thank you
Tony