Multi Records on same customer

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

Guest

I have a report that is giving me mutiple information on the same customer.
This did not do this in the past but all of a sudden it started. I am
pulling the information from a table that is updated once a month. The table
looks ok with only information for the customer on one line. Why has this
report started doing this? Please help me understand what is happening.
 
Could be a bug
Could be that the report is based on a query?

Can you quickly whip up a temp new report using auto wizard - just as a
sanity check?
 
Are you using a query or SQL statement for the RecordSource of the
report? If so, do you have joins to other tables? If you join to a
table that has multiple matching records, you'll get seemingly
duplicated records.

I have a report that is giving me mutiple information on the same customer.
This did not do this in the past but all of a sudden it started. I am
pulling the information from a table that is updated once a month. The table
looks ok with only information for the customer on one line. Why has this
report started doing this? Please help me understand what is happening.
Click to expand...
Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
jrp444 said:
I am using a table to make the report and there is no join to other tables.
Click to expand...

That's all I can think of that would cause this. I would take the
advice of another poster and create a simple report from scratch on this
same table to see where it goes wrong.
 
This report is not the only one that started doing this. The information
that I am aquiring has to go on more than one line. It seems that how many
lines of information I have on a record I get that many of the same account
in the report. Maybe this will key something and somebody might know what
the problem is.
 
jrp444 said:
This report is not the only one that started doing this. The information
that I am aquiring has to go on more than one line. It seems that how many
lines of information I have on a record I get that many of the same account
in the report. Maybe this will key something and somebody might know what
the problem is.
Click to expand...

Hold on now - where do the "lines of information" come from? Another
table? Or is your account information repeated in multiple records in
your single table?

Either way, it sounds as though you may need to set up Sorting and
Grouping in your report. The account information can be grouped into a
Header Section, and the "lines of information" can be left in the Detail
Section.
 
Back
Top