Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Getting query to show all dates, even if date has no data.

Discussion in 'Information Technology' started by Paid The Umpire, Jul 28, 2006.

  1. Paid The Umpire

    Paid The Umpire
    Expand Collapse
    Guest

    Thanks, that works fine.

    But now i need to to do it by also Client_Reference_Number.

    So i have a list of all dates with all totals for one and only one
    client. When i try i don't get the details for the null days. I just
    get the dates with data.

    Any ideas?
     
  2. Loading...


  3. Paid The Umpire

    Paid The Umpire
    Expand Collapse
    Guest

    Anybody?

    Paid The Umpire wrote:
    > Thanks, that works fine.
    >
    > But now i need to to do it by also Client_Reference_Number.
    >
    > So i have a list of all dates with all totals for one and only one
    > client. When i try i don't get the details for the null days. I just
    > get the dates with data.
    >
    > Any ideas?
     

Share This Page