Sum of visible cells in access report

[everwelwisher]

Hi friends

i have a field order amount
i have already set its property "hide duplicates" = yes



now i need a total of order amount in report footer

=sum(order_amt)

but it is taking the sum of all hidden duplicates as well

i need the sum of visible cells or data

thanks

nida tehreem

[ranman256]

Then you need a query that doesn't have the duplicates, or a DLOOKUP for the 1 field.

[everwelwisher]

thanks could you please write a sample query for me thansk