Hi Everyone,
          I'm trying to take 2 fields from an Access DB and put them in a report using a query. I want the query to display a part number and a figure index. I only want the part number to be displayed once and the figure index to be displayed as many times as it exists. I tried to filter the query by setting the "unique value" property to yes in the properties window but that didn't work. Anyone know what to do? THanks

Here is my SQL:
SELECT DISTINCT IPBData.[Part No], IPBData![Fig No] & "-" & IPBData!Index AS Expr1
FROM IPBData
WHERE (((IPBData.[Part No]) Is Not Null))
ORDER BY IPBData.[Part No], IPBData![Fig No] & "-" & IPBData!Index;

Todd,
Do you have any groupings set for your report?
If you create a part number group header, then in the detail line only show the index's.

HTH,
Kevin

dartcoach