ODBC tbl querie or not 1

[MarcoPerez21]

I have a calendar tbl the function for this tbl is to keep the week in month/ year organized for the POS software. my task is get the sales from today and copmare it against last years data on the same period regardless of the day (ie. sales for may 12,03 was a monday, sales fir may 12, 04 is wed)what I need is: (lets say that we are in wk 23 of 2003)week 23 of last year to compare sales. can anyone give insight on which way to go? query or not.


Thanks in advance,
Marco

 

[lespaul]

I think you just have to open qryGetAllData, it should run the others as needed to get the information.

Leslie

 

[MarcoPerez21]

Leslie,

I think that I left some of queries out!
I have a make table query that grabs the sales information from two ODBC tables : tixhdr, tixlin from those to I create the "Sales Data" tbl. I have a qry that grabs the information from the Sales Data and pumps the data into the "Daily Sales" Table this table is where I get the information to generate my report (by way of a master query) can you advise me with which qry i should start with.
thank you in advance,
Marco

 

[lespaul]

I believe that once you have created you Daily Sales Table that you should be able open GetAllData and it will run!

I don't know what your process is for creating that table, is it in a module?


leslie

 

[MarcoPerez21]

no it's not in a module
i've found the answer i was pointing to the wrong qry.
thanks
Marco

 

[lespaul]

Oh, good! I was running out of ideas of why it wasn't working!!

leslie