A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report Chart Preview is Perfect but not the Chart Results



 
 
Thread Tools Display Modes
  #1  
Old May 11th, 2010, 07:10 PM posted to microsoft.public.access.reports
Rob
external usenet poster
 
Posts: 1,029
Default Report Chart Preview is Perfect but not the Chart Results

I have a Query that only pulls in two fields of a table, one hidden and one
visible. The visible one is a date range that starts 1/1/2010 and ends
5/8/2010. The hidden field is the query qualifier that makes certain that
line items which are marked as "confirmed sent" are shown.

When I use the chart wizard I only pull in the date range as it is the only
one available and I choose the default column layout presented by the wizard.
When I use the "preview option" it looks perfect but when I I select finish
it give me that darn North, East, West with 1st, second, third, fourth,
quarter junk.

Can anyone explain what I am doing wrong and why the previews always show
correct but the actuals are the generic default?

Thanks in Advance,
Rob
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.