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

Finding data using multiple fields in grouped reports

P: n/a
I have trying to figure out the above topic. Can someone help me with
this?

I need for staff to be able to go to a dialog box or a form and then be
able to enter data in mutliple fields and then pull up a report.

I have tried parameter queries but it does not seem to work in a
grouped report. I put text boxes on the report but that did not work
either using a query and the text box. Please something simple as
possible as I am new to Access and it is giving me fits in this area to
say the least.

Thanks for any help.

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


P: n/a

Randy wrote:
I have trying to figure out the above topic. Can someone help me with this?

I need for staff to be able to go to a dialog box or a form and then be able to enter data in mutliple fields and then pull up a report.

I have tried parameter queries but it does not seem to work in a
grouped report. I put text boxes on the report but that did not work
either using a query and the text box. Please something simple as
possible as I am new to Access and it is giving me fits in this area to say the least.

Thanks for any help.


Create an unbound form with textboxes or comboboxes or whatever you
want to collect all your criteria. Then add a button. In the button's
code, loop through the controls on your form and build your filter
dynamically - if a control's contents are not null, then append that
[fieldname]=controlvalue to your filter string. Then pass that
completed Where clause to the open event of your report...
Yeah, if you're new to Access and VB, this WILL give you fits.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.