Re: How do I get my query to list months that have no data records?

A bit of complications since a Query cannot display data if data is not
there.

What you can do is to use a Query "Q1" to create a "dummy" Record for "zero"
for each month in the required year(s). You can then use a Union Query to
combine rows from Q1 and your actual Table so you have at least one row for
each month.

You can then do a Total Query which should have a total for each month (the
month without real Records showing zero) in the required year(s).

--
HTH
Van T. Dinh
MVP (Access)



"dsbnmhg" <dsbnmhg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:50EED9C8-2738-4DAD-B346-6D9E6AEBFEFC@xxxxxxxxxxxxxxxx
> I want to do a query of data and sum totals by month. Some months don't
have
> any records so they don't show up on my query. I want to have all months
> show up so I can use the query in a report or download into Excel and
account
> for all 12 months of each year. How do I make the empty months show up on
my
> query?


.

Relevant Pages

  • Re: Report is making too many numbers
    ... from the $'s being listed more than once in the query. ... And you want to display the sum of in the Vendor header or footer ... My report is based on a query. ... those records--you could create a Totals query by depressing the ...
    (microsoft.public.access.reports)
  • Re: a query to produce sales activity totals
    ... In query design view, depress the Total button on the toolbar Access adds a Total row to the query design grid. ... number of contacts and the varous steps they have taken in the sales process. ... put these totals into a spread sheet that shows each salesperson's numbers... ...
    (microsoft.public.access.queries)
  • Re: a query to produce sales activity totals
    ... The query generates a row for each salesperson, ... Allen Browne - Microsoft MVP. ... of the sales process, including the number of sold and delivered vehicles. ... put these totals into a spread sheet that shows each salesperson's ...
    (microsoft.public.access.queries)
  • Re: Running balance from two tables
    ... the TOTALS button and show a totals line in the query, ... my total additions and my total costs and see how much money is in my ... What I'd love to do with it is have something pop up when the balance is ...
    (microsoft.public.access.queries)
  • RE: Updating the 1st Instance of a Record
    ... As the others have pointed out you shouldn't store the totals but compute ... In a query you can return the total per order provided you don't ... This second query will return the total amount per order in every row of its ... and an unbound control in the group footer with a ControlSource ...
    (microsoft.public.access.gettingstarted)