PC Review


Reply
Thread Tools Rate Thread

Access2007 graph on report prob with reference to form

 
 
Mark Andrews
Guest
Posts: n/a
 
      16th Apr 2009
I don't use microsoft graph that often but am using it in Access2007 and
have the graph based on a query.

Works fine if when the where clause of the query is
WHERE (Year([InventoryMonth]) = 2009)

However doesn't work in I change the query to be
WHERE (Year([InventoryMonth]) = Forms!frmReport!ComboYear).

Note the form is open and the ComboYear control has the value 2009.

The query runs fine and displays same data but the graph will not display
any data.

I can construct the query in code but just wondered if there is a
workaround?

Thanks in advance,
Mark


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graph question in Access2007 Mark Andrews Microsoft Access 5 3rd Dec 2009 03:53 PM
Microsoft Graph Chart issue in Access2007 praveen Microsoft Access VBA Modules 1 7th Aug 2008 06:52 PM
Doing a form and report (with graph) thing online =?Utf-8?B?QmFzaWw=?= Microsoft Access Reports 3 9th Apr 2007 11:38 PM
Unable to insert a graph in a Form or Report. Christopher W via AccessMonster.com Microsoft Access Queries 0 19th Aug 2005 07:35 AM
Graph on form to report =?Utf-8?B?R3Jlbmllcg==?= Microsoft Access Reports 1 28th Oct 2004 05:41 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:49 PM.