I have attached an Excel spreadsheet of what my Access 2007 table looks like.
Currently I am displaying the results on a web page that has 3 select statements that produce results.
The first select statement gives me the "Total Sales" for the Week.
The second select statement gives me the "Total Sales" for the Day.
The third select statement gives me the "Detail Information" for the day.
1.) SELECT IIF(SUM(Sales) is NULL,0,SUM(Sales))
2.) SELECT SUM(Sales)
3.) SELECT *
My problem is, is if there are NO Bookings(Sales) today, (Select statements 2 & 3),
the Total for the week, (Select statement 1), does NOT display.
Is there a way of showing the total for the week even if there are NO sales today?
Any help would be greatly appreciated.