problems with repeating entries

R

richardunmpitt

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.
 
K

KARL DEWEY

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?
 
R

richardunmpitt

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.
 
Top