problems with repeating entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to run a query from a form. In the form I have numerous entries of the
same item. How can I run a query so that only the first entry is shown.
 
In the form I have numerous entries of the same item.
Do you mean you have numerous 'records' with the same entry?
What would constitute the 'first entry' or does each entry have a DateTime
stamp?
 
Yes, Sorry I mean numerous records. For example: we have a databasse for All
Star Game sleeve patches. We have 30 2006 Pittsburgh All Star Game patches,
each patch is listed in the form (and therefore each patch has ity's own id
number). I want to prepare a query that would only list one of the 2006 All
Star Game patches instead of all 30.
Thanks.
 
Back
Top