E
emanna
i posted this question on microsoft's message boards yesterday, but i
think maybe i didn't make myself very clear.
okay....i designed a report that lists assignments by person and then
gives a total for each assignment.
example:
smith deliveries 5
pick ups 2
jones deliveries 1
martin pick ups 7
when you run the report, i have a parameter in the query to ask for the
[Begin Date] and [End Date] so i can run the report for a certain time
frame.
the above so far works great. the problem comes in at the part of what
i want at the end of the report (in the report footer). i would like
to list all the assignments and a total for each one in the time frame
that i choose in the parameter. this of course would be taking all the
assignments that have been listed in the report by person, listing them
and then the total for each one at the end of the report.
example:
deliveries 6
pick ups 9
etc.
in the query that i am basing this report off of, i have a field for
assignments and then did a field to count those assignments. of course
also in this query is the name field and date field (which doesn't
show) and is where the parameter is located.
so far the only way that i can think to do this is to create a list box
in the report footer and base it off of the [assignments] and [count of
assignments].
now the list box does work, however, b/c it too is off the same query,
it prompts me to enter the parameter twice when running the report
(i.e. enter begin date, enter end date, enter begin date, enter end
date). the information that shows up in the report is correct, and
really the double parameter entry is nothing more then a pain in the
a$$.
there has got to be a way to total each of those assignments at the end
of the report without having to enter the parameter twice. i am sure
the list box is not the perfect route to go, but since i consider
myself to be a beginner with this, that is all i can think of.
someone please help and if something doesn't make sense, or more
information is needed to assist, please let me know.
think maybe i didn't make myself very clear.
okay....i designed a report that lists assignments by person and then
gives a total for each assignment.
example:
smith deliveries 5
pick ups 2
jones deliveries 1
martin pick ups 7
when you run the report, i have a parameter in the query to ask for the
[Begin Date] and [End Date] so i can run the report for a certain time
frame.
the above so far works great. the problem comes in at the part of what
i want at the end of the report (in the report footer). i would like
to list all the assignments and a total for each one in the time frame
that i choose in the parameter. this of course would be taking all the
assignments that have been listed in the report by person, listing them
and then the total for each one at the end of the report.
example:
deliveries 6
pick ups 9
etc.
in the query that i am basing this report off of, i have a field for
assignments and then did a field to count those assignments. of course
also in this query is the name field and date field (which doesn't
show) and is where the parameter is located.
so far the only way that i can think to do this is to create a list box
in the report footer and base it off of the [assignments] and [count of
assignments].
now the list box does work, however, b/c it too is off the same query,
it prompts me to enter the parameter twice when running the report
(i.e. enter begin date, enter end date, enter begin date, enter end
date). the information that shows up in the report is correct, and
really the double parameter entry is nothing more then a pain in the
a$$.
there has got to be a way to total each of those assignments at the end
of the report without having to enter the parameter twice. i am sure
the list box is not the perfect route to go, but since i consider
myself to be a beginner with this, that is all i can think of.
someone please help and if something doesn't make sense, or more
information is needed to assist, please let me know.