Parameter query/subreport mess

Hi! I posted this yesterday and now I can't find it in any of the topics. I
also can't remember what I titled it but I believe it had something to do
with ulcers.

I have a database that is collecting evaluations. I wanted to create a
report that looked for records from a specific course, semester and year.
The query is fine and the results are fine except I was unhappy with the
formatting (i.e., an individual respondent's comments for all questions are
in one glob, then the next, etc.). I wanted each type of comment (a single
field) to be printed/displayed in a single section. So I came up with the
idea of using subreports that would gather the data from the original
parameter query.

The problem is that each subreport now requires entry of the criteria every
time. That's 24 separate data entries to get each report. I created a form
for the entry, thinking this would solve the problem but noooooo...

Any help would be greatly appreciated!
.

Relevant Pages

  • Re: Date Data type and Parameters.
    ... "Wayne Morgan" wrote: ... You can't get a parameter query by itself to limit the user's input. ... then use an Input Mask for the textbox to limit the user's entry. ... I assume the reason you want the user to enter the date in the format you ...
    (microsoft.public.access.queries)
  • Re: Date Data type and Parameters.
    ... A format is just a display item. ... You can't get a parameter query by itself to limit the user's input. ... then use an Input Mask for the textbox to limit the user's entry. ...
    (microsoft.public.access.queries)
  • Query to select records by latest date
    ... I am working with a training db and each time a module is refreshed by a person a new entry is made. ... Assessment Date ... Expiration Date ... I have set up a parameter query to select records for individuals, however, I don't know how to select the latest record by date for each of their modules completed? ...
    (microsoft.public.access.gettingstarted)
  • Duplicate files returned when performing merge with a parameter query
    ... When I perform a mail merge with a parameter query using ... have looked at Knowledge Base Article 286847 and this is ... The table has only one entry for the ...
    (microsoft.public.word.mailmerge.fields)