Access 2003 (Chart within a Report) (Revised)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The Row Source is: TRANSFORM Count(*) AS [Count] SELECT
[RF Chart Query].Area FROM [RF Chart Query] GROUP BY [RF
Chart Query].Area PIVOT [RF Chart Query].Expr1;

Subject: Re: Access 2003 (Chart within a Report)
From: "Duane Hookom" <[email protected]>
Sent: 3/17/2004 8:08:41 AM




Provide us with the Row Source property of your chart. I
expect that it may
be a crosstab query.
Also, you should abandon parameter prompts in favor of
referencing controls
on open forms. This provides much more control and
flexibility.
 
Your RF Chart Query probably has a criteria like [Beginning Date] and
[Ending Date]. You need to open the Row Source in design view and select
Query|Parameters and enter the exact parameters and their data types:
[Beginning Date] Date/Time
[Ending Date] Date/Time

--
Duane Hookom
MS Access MVP

The Row Source is: TRANSFORM Count(*) AS [Count] SELECT
[RF Chart Query].Area FROM [RF Chart Query] GROUP BY [RF
Chart Query].Area PIVOT [RF Chart Query].Expr1;

Subject: Re: Access 2003 (Chart within a Report)
From: "Duane Hookom" <[email protected]>
Sent: 3/17/2004 8:08:41 AM




Provide us with the Row Source property of your chart. I
expect that it may
be a crosstab query.
Also, you should abandon parameter prompts in favor of
referencing controls
on open forms. This provides much more control and
flexibility.

--
Duane Hookom
MS Access MVP
Ron Kozak said:
I know that I have a previous post concerning this but
really need help. I have created a report in Access
2003. It consists of a regular report run from query RF
Issues Query. I also have a chart in that same report
run from query RF Chart Query. I have added a date
criteria in the RF Issues Query to select from Beginning
Date to Ending Date. The report also has a control
source to show these dates. The problem that I am having
is that I cannot get the chart to match the report. The
chart displays everything that was ever entered into the
table and the report itself shows the information that is
between the Beginning and End Dates, which is correct. I
even tried adding the same criteria to the RF Chart Query
but got the following error message: The Microsoft Jet
Engine Database does not recognize '[Enter Beginning
Date]' as a valid field name or expression. Is there
anyone out there that can help me fix this issue?

Thanks,
Ron
Click to expand...
Click to expand...
 
Back
Top