By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,137 Members | 2,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,137 IT Pros & Developers. It's quick & easy.

filter field for report - access97

P: n/a
I want to create a report that shows the percent of safety audits
complete by each individual shift, based on the safety audit date.
The user has to put in the dates they want the report to pull up. This
is done in a parameter value box.
Is there a way for the user to put in which shift to pull up, based off
a field that is a list box?

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Heather:

On the Criteria line for the shift field you can specify the list box value
to filter the records for only that shift. For example:

Forms!MyFormName!MyListboxName

This assumes that the list box is a single selection list box (as opposed to
a multi-select list box) and that the form with the list box is open at the
time the report is run. The user can then select the shift in the list box,
enter the dates in the parameter value box(es) , and the report query will
read the value of the list box.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Heather" <HW******@cox.net> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
I want to create a report that shows the percent of safety audits
complete by each individual shift, based on the safety audit date.
The user has to put in the dates they want the report to pull up. This
is done in a parameter value box.
Is there a way for the user to put in which shift to pull up, based off
a field that is a list box?
Nov 13 '05 #2

P: n/a
Heather:

Here is an additional reference regarding using form controls as parameters
for queries.

http://support.microsoft.com/kb/95931/EN-US/

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Heather" <HW******@cox.net> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
I want to create a report that shows the percent of safety audits
complete by each individual shift, based on the safety audit date.
The user has to put in the dates they want the report to pull up. This
is done in a parameter value box.
Is there a way for the user to put in which shift to pull up, based off
a field that is a list box?
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.