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.
 
You must log in or register to reply here.

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

Append Query Issue 0
Combine Duplicates in Query 0
Criteria in a Querie 8
Building Complex Criteria for Queries in Access 2007 1
Access Query for keeping a total hours remaining. 0
Query to Form View 1
Parameter Query Won't Run 0
Query to show 2 records from each unique entry in a field 2

Back
Top