Trying to create a title in my report

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

Guest

I am creating reports that are only one page charts in essense

The chart is based on a secondary query

The first query is a date count query to ensure that all entries are counted even if there are two on the same date. THIS IS THE PARAMETER QUERY

The second query is a count query for the specific parameter to be graphed/charted

I would like to create a title on either the report or chart that will give the date range that the chart is based upon

I am desparate!!! I need to finish this project ASAP

Thank Yo
Tammy
 
I would not use a parameter query. It is much better to have a user enter
dates in text boxes on a form. You can then reference the controls rather
than prompt for parameters.

--
Duane Hookom
MS Access MVP


Tammy said:
I am creating reports that are only one page charts in essense.

The chart is based on a secondary query.

The first query is a date count query to ensure that all entries are
Click to expand...
counted even if there are two on the same date. THIS IS THE PARAMETER
QUERY.
The second query is a count query for the specific parameter to be graphed/charted.

I would like to create a title on either the report or chart that will
Click to expand...
give the date range that the chart is based upon.
 
Charts have a Row Source property that is generally a saved query or a sql
statement. These queries can be filtered by setting a criteria. The method
you have apparently chosen is to use a parameter prompt so when the chart
attempts to print, the user is prompted for parameter values such as
starting and ending dates.

I recommend converting these queries so that they use a reference to a text
box (or other control) on a form. For instance, you could have a form
"frmDateSelect" with two text boxes "txtStart" and "txtEnd". Then, set the
criteria in your query to
Between Forms!frmDateSelect!txtStart And Forms!frmDateSelect!txtEnd
This allows you to check the date values for integrity, provide default
values, the user can see both dates at once,...
 
Back
Top