Report not listing duplicate records

[dizzkat]

I have a simple report that is linked to 1 Access db table. In the table, there is an Account# field and a Cost field. If there are multiple costs with the same amount associated with the account, then it only shows up one time in the report. But, if the amounts are different, then the report shows all the records correctly.

Account# 2345 Cost .74 (2 cost - same amount)
Account# 3456 Cost .88 (2 cost - different amount)

In the crystal report, #2345 will only show .37 once. But, #3456 will show a record for .37 and a record for .51.

How can I get it to show all the records even if they are duplicate? I've verified that there is no suppression if duplicate checked on all fields/details. Am I missing something? Any insight is greatly appreciated.

Many thanks,
Kathy

 

[synapsevampire]

How did you check for suppression if duplicates?

Check to make sure that Database->Select Distinct Records isn't turned on. This may only be an option if you're using ODBC to connect Access.

If so, also check Database->Show SQL Query, perhaps someone has used a Union to create a distinct select.

-k

 

[ajdesigns]

what fields do u have in your report