Parameters keep repeating

[Georgie047]

I have created a graph report . When I ask for the report from the
switchboard, I have to enter the date parameter associated with the query
more than once. I have to also enter the day again before I print. And if I
cancel. it prints a blank report. Is there a way I can view the report, enter
the dates, and print without repeated requests. I have battle with this for
months. I did try creating a form to associate with it and this still happens

 

[Duane Hookom]

IMHO, parameter prompts in queries are not good user interface
http://www.tek-tips.com/faqs.cfm?fid=6763.

Consider creating a form with controls that can be used for filtering. Add a
command button to open your report.

 

[Georgie047]

I created a form I have to texts boxes , begin and end date. when I click my
report command button created on the form to open a report, it asks for the
parameter values twice(dates). The graph then appears. If I cancel, a blank
prints out. When I select the print button, I am asked once again for the
dates, it then prints. I have been at this since August. . When I open the
report from the switchboard, (directly to the report) the same thing happens.
I don't know what to do. I have been stumped by this one and could use all
the help.

 

[Duane Hookom]

You should first open the form and enter the criteria/date values. Then open
your report.

 

[Georgie047]

In my last message I noted : when I click my
report command button created on the form to open a report, it asks for the
parameter values twice(dates). The graph report then appears. I click the

 

[Duane Hookom]

What are the parameters your record and row sources are looking for? What are
the SQL views of your Record Sources and Row Sources? These should identify
why you are being prompted.

 

[Georgie047]

the record source for the report is :
SELECT(Format([admissiondate],"MMM'YY")),Count([admissiondate]) AS
[CountOfadmissiondate]FROM[ALF admissions by month que] GROUP BY
(Year([admissiondate])*12+Month([admissiondate])-1),(Format([admissiondate],"MMM'YY"));

the query source for the report is: field:admission date; criteria: Between
[begin date] and [end date]

The SQL view for the query is: SELECT TBLRESIDENTINFO.unittype,
TBLRESIDENTINFO.admissiondate
FROM TBLRESIDENTINFO
WHERE(((TBLRESIDENTINFO.unittype)="ALF")AND((TBLRESIDENTINFO.admissiondate)
Between [begin date] And [end date]));

The SQL statement for the report is displayed in the RecordSource
-- the report was created with the wizard. The report works fine except for
the problems noted. A form to open the report has not been created (even
though I tried)

I do thank you in advance for your help and pray this makes sense.
Thanks, Linda

 

[Duane Hookom]

You shouldn't use
Between [begin date] And [end date]
I would expect to see some references to the controls on your form like:

Between Forms!frmDates!txtBeginDate And Forms!frmDates!txtEndDate

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

the record source for the report is :
SELECT(Format([admissiondate],"MMM'YY")),Count([admissiondate]) AS
[CountOfadmissiondate]FROM[ALF admissions by month que] GROUP BY
(Year([admissiondate])*12+Month([admissiondate])-1),(Format([admissiondate],"MMM'YY"));

the query source for the report is: field:admission date; criteria: Between
[begin date] and [end date]

The SQL view for the query is: SELECT TBLRESIDENTINFO.unittype,
TBLRESIDENTINFO.admissiondate
FROM TBLRESIDENTINFO
WHERE(((TBLRESIDENTINFO.unittype)="ALF")AND((TBLRESIDENTINFO.admissiondate)
Between [begin date] And [end date]));

The SQL statement for the report is displayed in the RecordSource
-- the report was created with the wizard. The report works fine except for
the problems noted. A form to open the report has not been created (even
though I tried)

I do thank you in advance for your help and pray this makes sense.
Thanks, Linda

What are the parameters your record and row sources are looking for? What are
the SQL views of your Record Sources and Row Sources? These should identify
why you are being prompted.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm