Re: parameter query

No: you can't do that John. A parameter can only be a value; it cannot be a mix of various values, separators, operators, ...

You could get the report you want by building a WhereCondition string to filter the report. Here's an example:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<jlute@xxxxxxxxxxxx> wrote in message
news:49fc650c-51e0-440e-adf8-4e8b2fbb5ab5@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I know how to create a parameter query. What I'd like to do is run a
parameter query that displays many child records of one parent record
that permits multiple parameter entries for the primary key. Can this
be done?

For example, the query returns:

ID (pk)
12345
12346
12347
12348
12349

I may only want the report to display:
12345
12348
12349


I can't see how this could be done via a parameter query.

Does anyone have any ideas? Thanks in advance!

.

Relevant Pages

  • Re: Use a form to query a report
    ... Selection" function to decide what records will be delivered to the report. ... If you filter for City, the report will be filtered for City. ... > need to do from here to complete the parameter query according to your ...
    (microsoft.public.access.gettingstarted)
  • Re: parameter query
    ... (Generally we do the reverse, the field is at the left and the parameter is the pattern, at the right, of the operator LIKE). ... You could get the report you want by building a WhereCondition string to filter the report. ... parameter query that displays many child records of one parent record ...
    (microsoft.public.access.queries)
  • Re: parameter query
    ... You could get the report you want by building a WhereCondition string to ... Use a multi-select list box to filter a report ... parameter query that displays many child records of one parent record ... I can't see how this could be done via a parameter query. ...
    (microsoft.public.access.queries)
  • Re: Report Header
    ... In the 3rd argument of the DLookUp I posted: ... > Since this report references a parameter query as it's record source, ... > the report is based on) is the one the report recognizes. ... >> I guess the DeptNo uniquely determines the DeptName? ...
    (microsoft.public.access.reports)
  • Re: Questions on Control boxes, Parameter queries and calendars in
    ... >> created a report that is based on a parameter query. ... I would liek the agency box to be a drop down list so the ... I would like the parameter prompts for the beginning and ...
    (microsoft.public.access.reports)