Duplicate Records in a Report

  • Thread starter Thread starter Rohit
  • Start date Start date
R

Rohit

Hi All,

I have a query where the data appears to be perfect;
however, when I print a REPORT I see Duplicate Records. I
don't know why? I did try to Group em'', but it doesn't
work.

Can someone Help.

Here is an example in the query section:
Date Rec.| Tally Number | Part Numbers
01/23/04 0001 abcd
01/23/04 0001 zsdf
01/23/04 0001 dsdf

However, in Report.
Date Rec.| Tally Number | Part Numbers
01/23/04 0001 abcd
01/23/04 0001 zsdf
01/23/04 0001 dsdf
01/23/04 0001 abcd
01/23/04 0001 zsdf
01/23/04 0001 dsdf
Please Help.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You must have only one Control on the report's Detail section per
column in the query. Do you have that? Are there other Control's in
other sections with the same ControlSource as the Detail section
controls?

There are many other possibilities, which are hard to evaluate w/o
seeing the report (which I don't want to see). Just check to see if
you have more than one Control w/ the same ControlSource.

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQB6jNIechKqOuFEgEQJgEgCdEcfkHVdtjA3ZybiY2uEACtyQ8agAoIfl
YHXtOHJ4J4ayJh2/F2Kner5/
=4xdB
-----END PGP SIGNATURE-----
 
Back
Top