ThaNguyen
06-05-2008, 09:44 AM
Hi,
I have a spreadsheet that have many tabs aka w1,w2,w3.... and so on. I have a table that queried one of those tab example bottom
SELECT `W48$`.Cost, `W48$`.`Customer Name`, `W48$`.`Customer#`, `W48$`.GP, `W48$`.Margin, `W48$`.Qty, `W48$`.Sales, `W48$`.Wgt, `W48$`.WK
FROM `C:\sales\WK06`.`W48$` `W48$`
Every week I would go into the sql and edit w48 to w49 and so on.
I would like to put this a macro that I could just change the # so I dont have to manually change it every time.
any help would be greatly appreciated
I have a spreadsheet that have many tabs aka w1,w2,w3.... and so on. I have a table that queried one of those tab example bottom
SELECT `W48$`.Cost, `W48$`.`Customer Name`, `W48$`.`Customer#`, `W48$`.GP, `W48$`.Margin, `W48$`.Qty, `W48$`.Sales, `W48$`.Wgt, `W48$`.WK
FROM `C:\sales\WK06`.`W48$` `W48$`
Every week I would go into the sql and edit w48 to w49 and so on.
I would like to put this a macro that I could just change the # so I dont have to manually change it every time.
any help would be greatly appreciated