Query first record.

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

First question;

What Query criteria would I use to find the first
occurrence only of a record name in any particular field.


Second question;

I want to compare two list and see the items that appear
on 1 list only. If each list contains the same item I
don't need to see it.
 
Dear Eric:

In order to find the "first" occurrance you must have a specific
definition of what you mean by "first" based solely on the values in
the rows of the query.

To find those rows that appear on only 1 "list" you should make a LEFT
JOIN between that list and (on the right) the other list. Then filter
for only those rows where a selected field from the one on the right
IS NULL.

Your questions are asked in very general terms, and these answers are
also very general. For more specific, details responses, you should
provide details on which to base such responses if that is what you
need.

First question;

What Query criteria would I use to find the first
occurrence only of a record name in any particular field.


Second question;

I want to compare two list and see the items that appear
on 1 list only. If each list contains the same item I
don't need to see it.
Click to expand...

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top