Pulling out right ID number

  • Thread starter Thread starter Lars Brownies
  • Start date Start date
L

Lars Brownies

In a criteria form I have 10 comboboxes of which, if filled, its values
are used as criteria in corresponding queries (on different linked tables)
which all result in an independent set of the same type of ID numbers.

Now I only want to pull out those ID numbers of the records that meet all
criteria. With every solution I think of I end up with a lot of match
queries and I assume there is an easier way. What would be the best way to
do this?

Thanks,

Lars
 
Thanks. The only problem in my case is that the criteria are set on the main
table as well as child tables. It seems to me that the filter option, as
shown in Allen's example form isn't an option then.

Lars
 
Mmm,
in that situation, I combine all the tables into a query for the main form
and get rid of the subform.

If that is not an option for you, I don't know what else to suggest.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Distinct will only make sure that all unique ID numbers are there. It won't
take care of my need to get the ID numbers that meet all criteria.

Lars
 
Thanks. I'll do some more fiddling.

Jeanette Cunningham said:
Mmm,
in that situation, I combine all the tables into a query for the main form
and get rid of the subform.

If that is not an option for you, I don't know what else to suggest.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
Click to expand...
 
Back
Top