Report Help

[sandman43103]

I am creating a database that tracks Sports Cards. There are many different players over many different years, form many different manufacturers. Basically, here is what I get when I do a basic report for data.


Cards Broke Down By Year
Year Manufacturer Card Set/Insert Players Name Serial # Game-Used Team

2002-03 Finest 123 Autograph Ely, Melvin 444/99 Yes Los Angeles Clippers

I would like to create a report that would show that Ely,Melvin played for the Clippers in 2002-03, and only one instance. When I do the report, it lists all the cards for this condition, but I want to just list one.

 

[cghoga]

are you only pulling data for a specific player, or are there many different players on the report.

if you've got it set up to only pull a certain player, in your query (that serves as the record source for your report) change the select statement to include
Select Top 1... and it should only give one instance.

like this:

Select Top 1 * from YourTableName

if this doen't work try Select Distinct or Select Distinct Row


hope this helps you.