Results 1 to 3 of 3
  1. #1
    templeowls is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    305

    Bar graph of monthly data...can it show a month even if the data is zero?

    Basically I've got reports pulling in complaints by month for each of our locations. The graphs are pulling off a query and the query is just filled with the actual complaints and their submission date. Also in the query is a monthnumber function so that the graph organizes the months in chronological order.



    My issue now is that some locations didn't have a complaint in April. So the graph jumps from March to May. It's a bit confusing and someone could misconstrue the data if they don't look closely. My question is their a way to populate April, for instance, in the graph but just have the bar be blank.

    Thanks!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    build a 'report' table.
    1. dump all the dates for the month used into the table with zero values
    2. append all your data into the rpt tbl in that range
    3. the query would sum all this data. use this in the chart/report.

  3. #3
    templeowls is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    305
    Dump all the dates of complaints into a table? Does that solve my issue still? Because again, there were no complaints in April so there's not going to be any dates in April to dump in. How would the report know to report on APril?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query to show data up to end of month before
    By Pure Salt in forum Queries
    Replies: 4
    Last Post: 08-21-2017, 01:45 PM
  2. Last Month Data Using Month Field, Access 2013
    By Biplab1985 in forum Queries
    Replies: 4
    Last Post: 02-27-2017, 06:26 AM
  3. Replies: 2
    Last Post: 02-12-2015, 05:14 AM
  4. Replies: 3
    Last Post: 01-05-2015, 02:21 PM
  5. Monthly Data
    By tsorange in forum Database Design
    Replies: 1
    Last Post: 11-09-2011, 02:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums