MarcoPerez21
Programmer
I have to select week/ period information from an odbc to pump it into my Sales report qry. does anyone have any suggestions to doing this.
My sales table records the sales information on the week & Period columns in each record row.
for instance if today and yesterday
it would show up:
week period date
1 12 5/10/04
1 12 5/11/04
I am also to pull the prior years data on these week/ period criteria
My sales table records the sales information on the week & Period columns in each record row.
for instance if today and yesterday
it would show up:
week period date
1 12 5/10/04
1 12 5/11/04
I am also to pull the prior years data on these week/ period criteria
