Hello everyone. This is my first post here so hopefully I am able to explain myself well.
I have 3 queries that get information for different stores for different days. Query 1 is Daily, Query 2 is Week-to-Date, and Query 3 is Month-to-Date.
These three queries are good but my problem occurs when I try to combine them in a new query.
In the new query I have the information for these three queries and a table called "t_StoreNums". The reason I added the table was because I want all the store numbers to show up even if I have no data for them for that day, week, or month; I want it to be a zero if there's no data. This is where I am stuck. I don't know how to do that and it gets worse (in my opinion).
If I have data for store #003 for monthly but not daily or week-to-date then it doesn't show up for monthly either, it just skips that store number.