Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-02-2008, 01:11 PM   #1
ysquared86
Registered User
 
Join Date: Nov 2008
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
ysquared86 is on a distinguished road
Pivotchart: months with no data

I (a total noob, i know) am trying to generate a pivotchart in a query that shows [quantity shipped] v. [month] relationship for each [product] in our database. However, the months in which no shipments are made do not show up on the pivottable/pivotchart, and i was wondering how to get all the months displaying.

for example, let's say product A has only been shipped out in april, august and july...then the chart only shows the quantity shipped for these three months. i want it to display january, february, etc...with quantity value of 0.

i hope that's not too vague. i feel like if you read above, you can get a gist of what i'm trying to do, but gurus seem never to fail to make beginners feel stupid by telling them how non-specific they are being first...

but please help.

ysquared86 is offline   Reply With Quote
Old 12-03-2008, 07:25 AM   #2
ysquared86
Registered User
 
Join Date: Nov 2008
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
ysquared86 is on a distinguished road
Re: Pivotchart: months with no data

Anyone?
I can clarify things...let me know what I can clarify.
ysquared86 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem displaying query data in Pivotchart papadega3000 Queries 0 05-21-2008 07:21 AM
Importing new data from Excel w/o matching keys dlukas Tables 1 01-27-2007 11:53 AM
Import Spreadsheet Data into Access mmitchell General 1 02-10-2005 02:40 PM
Else If.....claen programming datacontrol Reports 6 09-15-2003 05:54 AM
Last 12 months of data. ddbrook Queries 3 11-05-2002 06:22 AM




All times are GMT -8. The time now is 06:20 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World