Help with Report

[Guest]

I have figured out my problem

I want to create graph reports for certain time frames, for certain variables. Problem is that some dates are the same, so when doing the count, if I do not do the query in two steps (date count then variable count) the results are not accurate. SO I set up a parameter query and a count query. I can now get nice graphs. Problem is that I cannot put the date range in the title of either the graph or the report. It has been suggested that I use a question form instead of parameter query. I do not know how to do this at all

If I use this format can I put the four graphs I am making for the date range in the same report? How can I put the dates in the title of the report then

So basically, if someone could explain to me how to set this up so the user is asked once for the date, it appears in the title of the form, and I can fit the 4 reports for the same date range on one page, I would be so greatful. All four charts use the same step one, so I think once I understand the process let me know

 

[Bruce]

Check this topic in the Access Help Answer Wizard:
Print the criteria for a report in the report header

-----Original Message-----
I have figured out my problem.

I want to create graph reports for certain time frames,

for certain variables. Problem is that some dates are the
same, so when doing the count, if I do not do the query in
two steps (date count then variable count) the results are
not accurate. SO I set up a parameter query and a count
query. I can now get nice graphs. Problem is that I
cannot put the date range in the title of either the graph
or the report. It has been suggested that I use a
question form instead of parameter query. I do not know
how to do this at all.

If I use this format can I put the four graphs I am

making for the date range in the same report? How can I
put the dates in the title of the report then.

So basically, if someone could explain to me how to set

this up so the user is asked once for the date, it appears
in the title of the form, and I can fit the 4 reports for
the same date range on one page, I would be so greatful.
All four charts use the same step one, so I think once I
understand the process let me know.

 

[Dave]

I haven't followed your entire thread so if you've already
tried this then forgive me.
I wrote a report yesterday that used the parameter in the
following header line and it worked fine.

="IT Value of Unscheduled Eliot Deliveries for the
Period " & [StartDate] & " through 3/31/2004"

Whatever was typed as the StartDate appears in the header
of the report. [StartDate] is a parameter of a date field
used in the underlying select query for the report. The
key is that the parameter must be unique to any other
field or control name.

-----Original Message-----
I have figured out my problem.

I want to create graph reports for certain time frames,

for certain variables. Problem is that some dates are the
same, so when doing the count, if I do not do the query in
two steps (date count then variable count) the results are
not accurate. SO I set up a parameter query and a count
query. I can now get nice graphs. Problem is that I
cannot put the date range in the title of either the graph
or the report. It has been suggested that I use a
question form instead of parameter query. I do not know
how to do this at all.

If I use this format can I put the four graphs I am

making for the date range in the same report? How can I
put the dates in the title of the report then.

So basically, if someone could explain to me how to set

this up so the user is asked once for the date, it appears
in the title of the form, and I can fit the 4 reports for
the same date range on one page, I would be so greatful.
All four charts use the same step one, so I think once I
understand the process let me know.

 

[Marshall Barton]

I have figured out my problem.

I want to create graph reports for certain time frames, for certain variables. Problem is that some dates are the same, so when doing the count, if I do not do the query in two steps (date count then variable count) the results are not accurate. SO I set up a parameter query and a count query. I can now get nice graphs. Problem is that I cannot put the date range in the title of either the graph or the report. It has been suggested that I use a question form instead of parameter query. I do not know how to do this at all.

If I use this format can I put the four graphs I am making for the date range in the same report? How can I put the dates in the title of the report then.

So basically, if someone could explain to me how to set this up so the user is asked once for the date, it appears in the title of the form, and I can fit the 4 reports for the same date range on one page, I would be so greatful. All four charts use the same step one, so I think once I understand the process let me know.

To use a form for the query parameters, create a form with a
text box for each parameter and a command button to open the
report. Then, change the query's parameters from prompt
strings (e.g. [Start Date]) to refer to the text boxes on
the form (e.g. Forms!nameofform.nameoftextbox).

To use the form's text box values in the report, use an
expression that references them the same way:

="Start Date: " & Forms!nameofform.nameoftextbox