limiting query results to 1 per record

  • Thread starter adullam04-excelgoogle
  • Start date
A

adullam04-excelgoogle

My database has data summarizing reports. Each report has a
designator, and each report has the potential for multiple codes within
the "type" field.

I am running a query to feed a report. The search criteria for the
query includes multiple codes for the type field. As a result, if a
report has several of the codes in the type field, I get several
instances of the report designator listed in the query.

Is there a way to modify the query so that regardless of how many times
one of the type codes is found, the designator is only identified once?

Any help would be greatly appreciated.
TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select distinct 3
Query for two fields in one record that do not match 3
Can't create a report from my query in Access 1
number of events 2
Total appointments per agent 2
Query returns 9 records with criteria that exists in one record 2
Multiple criteria from a single field in a Select Query 1
query criteria - global variable 2

Top