Pivot Table - Parameter Querie

[Minkowski]

Hello everyone i have 7 workbooks (one for every day of the week)
with sales for that day.

all data come from a master table in Access
so i made 7 queries where i filter the weekday
and each workbook get external data from the specific query

can't i do it with a parameter query in excel somehow?
just a way to replace the 7 queries...
thanks in advance!

 

[alansidman]

I think that you should be able to query your Access db from Excel using MS Query. Here is a procedure for setting up a parameter query.

http://office.microsoft.com/en-us/excel-help/customize-a-parameter-query-HP010216113.aspx

Alan

 

[Minkowski]

i am not very good at this
i have the parameter query ready
but my excel file is empty

so i lost them at step 1

In Microsoft Excel, click a cell anywhere in the external data range created with a parameter query.

thanks though

 

[alansidman]

Sorry,
Perhaps you should start here. My bad in assuming you understood how to make an MS Query in Excel.

http://office.microsoft.com/en-us/e...retrieve-external-data-HA010099664.aspx?CTT=3

Alan