parameter query
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: 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) - JOIN query: What happens when you delete a row?
... Start with two tables, parent records in one and child records in the other, ... Now display fields from that query in a continuous form. ... one of the child records AND THE PARENT record are ...
(comp.databases.ms-access) - form display
... I designed a form that has a parameter query as a record source. ... is no data for the query selection the empty form doesn't display for some ... permissions the form does display and shows no data. ... I believe this could be related to permissions. ...
(microsoft.public.access.forms) - RE: Combo Box works, but top line displays blank
... opens the user is asked to type in the short name of a product. ... then brings up a cocatenated list of items that match the parameter query. ... When I click on the drop-down arrow, ... display the combo box with the first result in the list rather than having to ...
(microsoft.public.access.forms) - Parameter Query And Double click
... I have a Access 2003 database that shows our shipping information. ... have an order status form that is driven by a parameter query. ... double click on one of the other order numbers and display that order's ...
(microsoft.public.access.forms) |
|
