Re: parameter query

Thanks, Michel! I was just starting to get a grip on Allen's
suggestion but now that he's enamored with yours I'm torn!

I don't know that I fully understand your suggestion. Do I still
create a form with a listbox to select the records...? I'm a bit
lost.

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

Like passing a kidney stone?

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).

So I create a field in my query...yikes...I'm really lost here!

"Allen Browne" <AllenBro...@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.

<jl...@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!- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • Re: now ~CT-infested -- Re: Q: For Sy Liebergot (Yeah, its new safe CT-free topic fo
    ... > OCRing the report as you have whining and mewling that no one will do ... if the need is deemed important enough then extra work will need ... recommend tasking the laziest person in the group to do it. ... have yet to see anyone here choose to BUILD upon the suggestion. ...
    (sci.space.history)
  • Re: Winfixer
    ... I took on board one suggestion to get the ... It is suggested that you execute each tool in Normal Mode then in Safe ... Download Adware-Virtumundo Removal Tool -- ... On Win9x/ME platforms the report will not be ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Winfixer
    ... | I took on board one suggestion to get the latest version of Sun Java which I ... Download Adware-Virtumundo Removal Tool -- ... On Win9x/ME platforms the report will not be shown in your bowser ... It would be best to scan in both Safe Mode and in Normal Mode and save a copy of the HTML ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Word 2008 "Word Cannot Open this Document"
    ... report to M$) from PC's, from changing fonts, from cutting and pasting, ... 3- Drag the file from Finder to the app icon in the Dock ... gained by posting a "me too" as a reply - watch for the suggested solutions ... contribution or suggestion to offer on the ...
    (microsoft.public.mac.office.word)
  • Re: For Duane Hookum
    ... Ive got your suggestion to work now. ... and set the textboxes font size to 16, then I made the box narrow, ... Duane Hookom wrote in message ... >> report, although its not actually shown as a field on the report. ...
    (microsoft.public.access.reports)
Loading