The "Incident number" field has many duplicate incident numbers, which represent different pieces of equipment responded to an emergency call. I want to create a table that just pulls each unique incident number with it's other corresponding information to create a new table.
Is this what you are talking about:
(select min (MODIFIED INCIDENT NO) from EMSOnlyCalYear2012)
I had to pull the "MODIFIED INCIDENT NO" down into a second query field as the * field doesn't allow criteria
I get a "syntax error" when I try to run it.
Syntax error in query expression '(((EMSOnlyCaiYear2012.[MODIFIED INCIDENT NO]}=(select min (MODIFIED NCIDENT NO) from EMSOnlyCaiYear2012)))'.
Yes, Access 2010
here it is:
It doesn't matter as long as it just selects one incident number and excludes the duplicates
OK I'll await the download link.