Daily & Weekly Table - Query for weekending

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top