Problem with a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:
The report that I am working with takes data from a subform. The problem
that if the data entered into the subform is repetitive as shown below:

Lot # Lot Amount Lot Value
100 50 200
101 50 200
102 50 200

The report will appear as shown below:

Lot # Lot Amount Lot Value
100 50 200
101
102


If I set the report up to show duplicates in the fields it repeats
everything three times. I just want the report to appear as it does in the
first example.

Help!!!!
Robert
 
You're description and desired result are confusing, because if you set the
Hide Duplicates property to true for Lot Amount and Lot Value, then you
should get the result as seen in the top example?

So, I guess I don' t understand how it "duplicates everything three times",
or why that is wrong.

Also, reports don't get their data from Subforms. They get the data for
either a table or query, just like subforms do.

Finally, report related questions may get a better / faster answer in the
reports newsgroup.
 
Back
Top