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

User-input for Report

P: n/a
Hi there,

I don't have a lot of experience with this so I am looking for some
help.

I have a form that allows a user to choose the options she wants. How
do I set it up so that the report generated reflects those options?

Another issue is that I want the report to show totals. These totals
are organized with columns "Programs" and "Levels of Processing." The
"Levels of Processing" refers to the "Teams" field in the DataRecords
table. There are 4 different teams but I want to lump together three
of the teams into one. So, for every program there will be totals for
the "two" different teams where the second team actually includes the
totals from 3 teams. Under the column "Level of processing", in the
text box, I only want it to show these two teams....i.e. if it sees
Team A, it will say "Team A", but if it sees either Team B, Team C, or
Team D, I want it to say Team B for all of them because, like I said,
I am lumping 3 teams into one for the purpose of totals. There is a
purpose for having these as seperate teams, but that purpose does not
apply to this particular report.

Thanks for any assistance.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
o6***@unb.ca (Steven Stewart) wrote in message news:<58**************************@posting.google. com>...
Hi there,

I don't have a lot of experience with this so I am looking for some
help.

I have a form that allows a user to choose the options she wants. How
do I set it up so that the report generated reflects those options?
*WHAT* options can she choose? Filters? If that's the case, build
the filter (a valid WHERE clause without the word "Where" and then
pass that in the DoCmd.OpenReport command...
Another issue is that I want the report to show totals. These totals
are organized with columns "Programs" and "Levels of Processing." The
"Levels of Processing" refers to the "Teams" field in the DataRecords
table. There are 4 different teams but I want to lump together three
of the teams into one. So, for every program there will be totals for
the "two" different teams where the second team actually includes the
totals from 3 teams. Under the column "Level of processing", in the
text box, I only want it to show these two teams....i.e. if it sees
Team A, it will say "Team A", but if it sees either Team B, Team C, or
Team D, I want it to say Team B for all of them because, like I said,
I am lumping 3 teams into one for the purpose of totals. There is a
purpose for having these as seperate teams, but that purpose does not
apply to this particular report.


If you want to lump these together, you'll have to do the "lumping" in
a query so that they're all processed as having some value in common.
Then group by that calculated value

something like IIF(MyField="X","X","Y") and then you'd get two groups,
X and Y.
Nov 12 '05 #2

P: n/a
On 10 Nov 2003 12:16:50 -0800, o6***@unb.ca (Steven Stewart) wrote:
Hi there,

I don't have a lot of experience with this so I am looking for some
help.

I have a form that allows a user to choose the options she wants. How
do I set it up so that the report generated reflects those options?


Have the report's underlying query reference the controls on your form
used for specifying the report parameters.

Chuck
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.