Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012

    Question Unanswered: Query Not Showing all Values

    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.
    Please help.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    Please post the SQL of the queries as well as relevant information about the tables involved.
    Have a nice day!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts