Re: parameter query

There are some 'way around', but that can be slow.

A possible one is to pass the parameter: "12345,12348,12349"

(note there is no space after the comas)


And to use the query:

.... WHERE ("," & parameter & ",") LIKE ("*," & id & ",*")


ie, use the field as a pattern and the parameter as left argument of LIKE.
(Generally we do the reverse, the field is at the left and the parameter is
the pattern, at the right, of the operator LIKE).


Vanderghast, Access MVP


"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:%23rFnOG61IHA.2384@xxxxxxxxxxxxxxxxxxxxxxx
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: 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)
  • Re: parameter query
    ... 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 ... I can't see how this could be done via a parameter query. ...
    (microsoft.public.access.queries)
  • Re: Drill Down to other detail
    ... My report is based on a parameter query, ... Can I use a parameter query with a form? ... Place the memo field, of the main form, below the subform. ...
    (microsoft.public.access.queries)