K
Kevin Labore
Hi
I have a table that contain budget info for weekending date (sat). I have
another table which contains daily info (Sales, and other statistical info)
DailySalesTable:
DlyDate (contains the date where the sales occurred)
DlySales( Actual Gross sales for that day)
DlyUnits (Actual units sold that day)
BudgetTable:
WeekEndDate (the week ending date (sat))
BudSales (The budget Sales)
BudHoursDeptA
BudHoursDeptB
BudUnits
(also has the fiscal info -- Fiscal year, Fis period, Fis week)
I am Trying to build a query that would show the data by the weekEnding
Date(Also a Sat (unless Christmas falls on a Saturday then that day would be
empty) however that budget info would still be that Sat --- there just be no
actual sales
I know this should be fairly simple as I have build many cross tabs but not
with tables with different date ranges(daily & Weekly) Also I simplified the
tables there are more items which I will be comparing budget vs. actual.
Can someone either show me an example or tell me where to find examples of
above
Thanks in advance.
Kevin
I have a table that contain budget info for weekending date (sat). I have
another table which contains daily info (Sales, and other statistical info)
DailySalesTable:
DlyDate (contains the date where the sales occurred)
DlySales( Actual Gross sales for that day)
DlyUnits (Actual units sold that day)
BudgetTable:
WeekEndDate (the week ending date (sat))
BudSales (The budget Sales)
BudHoursDeptA
BudHoursDeptB
BudUnits
(also has the fiscal info -- Fiscal year, Fis period, Fis week)
I am Trying to build a query that would show the data by the weekEnding
Date(Also a Sat (unless Christmas falls on a Saturday then that day would be
empty) however that budget info would still be that Sat --- there just be no
actual sales
I know this should be fairly simple as I have build many cross tabs but not
with tables with different date ranges(daily & Weekly) Also I simplified the
tables there are more items which I will be comparing budget vs. actual.
Can someone either show me an example or tell me where to find examples of
above
Thanks in advance.
Kevin