duplicate reports

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

Guest

How do i get the report to print only one. it does show as a duplicate in my
queries, but not in the tables.
 
rludden said:
How do i get the report to print only one. it does show as a duplicate in my
queries, but not in the tables.
Click to expand...


Then either there is somethin wrong in you query (probably
joining too many tables) or your report needs to group on
the the duplicate part of the records.

I will need more information before I can speculate further.
 
I have checked all margins and the can shrink and grow is set to yes. Tables
is showing only one po number and when i open the queries it has the same
record twice. The data is on the reports. I can adjust the margins to redue
to one page. Then I have a two blank pages and two pages of the exact same
record. Help guide to what else you will need. I am soooo new at this.

thank you Rose
 
Let's not get distracted by some spacing issue and stick the
the problem in the query and don't waste your time trying to
analyze the report until after we get the query to generate
the correct set of records.

I would need to see a Copy/Paste of the query's SQL view to
be sure, but it sounds like the query has multiple tables
joined, the PO table, the PO details table and probably some
other table.
 
Would you tell me how to find the SQL to copy and paste?

Marshall Barton said:
Let's not get distracted by some spacing issue and stick the
the problem in the query and don't waste your time trying to
analyze the report until after we get the query to generate
the correct set of records.

I would need to see a Copy/Paste of the query's SQL view to
be sure, but it sounds like the query has multiple tables
joined, the PO table, the PO details table and probably some
other table.
--
Marsh
MVP [MS Access]

I have checked all margins and the can shrink and grow is set to yes. Tables
is showing only one po number and when i open the queries it has the same
record twice. The data is on the reports. I can adjust the margins to redue
to one page. Then I have a two blank pages and two pages of the exact same
record. Help guide to what else you will need. I am soooo new at this.
Click to expand...
Click to expand...
 
SELECT PO.PONUM, PO.PODATE, PO.AUTHBY, PURCHREQ.PRNUM, PURCHREQ.REQUIREDDATE,
PURCHREQ.PROMISEDDATE, PURCHREQ.SHIPVIA, PURCHREQ.WONUM,
PURCHREQ.REQUESTEDBY, PURCHREQ.GLNUM, VENDORS.VENDORNAME, VENDORS.VADDR1,
VENDORS.VADDR2, VENDORS.VCITY, VENDORS.VST, VENDORS.VZIP, VENDORS.VPHONE1,
VENDORS.VFAX, VENDORS.VCONTACT, Users.Name, GLNUMBERS.GLDESCRIP,
GLNUMBERS.GLNUM, PURCHREQ.SHIPPINGCOST, PURCHREQ.TAXCOST, PURCHREQ.FOB,
PRTOTAL.SUBTOTAL, PRTOTAL.SHIPPINGCOST, PRTOTAL.TAXCOST, PRTOTAL.GRANDTOTAL,
CDbl([PURCHREQ].[GLNUM]) AS BUDGETACCT, TyrexShippingLocations.SCOMPANYNAME,
TyrexShippingLocations.SADDRESS1, TyrexShippingLocations.SADDRESS2,
TyrexShippingLocations.SCITY, TyrexShippingLocations.SSTATE,
TyrexShippingLocations.SZIP, TyrexShippingLocations.SPHONE,
TyrexShippingLocations.SFAX, TyrexBillingLocations.BCOMPANYNAME,
TyrexBillingLocations.BADDRESS1, TyrexBillingLocations.BADDRESS2,
TyrexBillingLocations.BCITY, TyrexBillingLocations.BSTATE,
TyrexBillingLocations.BZIP, TyrexBillingLocations.BPHONE,
TyrexBillingLocations.BFAX
FROM (((((VENDORS INNER JOIN (PURCHREQ INNER JOIN PO ON PURCHREQ.PRNUM =
PO.PRNUM) ON VENDORS.VENDORID = PURCHREQ.VENDORID) INNER JOIN Users ON
PURCHREQ.REQUESTEDBY = Users.EmployeeID) INNER JOIN GLNUMBERS ON
PURCHREQ.GLNUM = GLNUMBERS.GLNUM) INNER JOIN PRTOTAL ON PURCHREQ.PRNUM =
PRTOTAL.PRNUM) INNER JOIN TyrexShippingLocations ON PO.SHIPTO =
TyrexShippingLocations.SLOCATIONID) INNER JOIN TyrexBillingLocations ON
PO.BILLTO = TyrexBillingLocations.BLOCATIONID;

Here you go. Thank you
 
rludden wrote:

[snip select clause]
FROM (((((VENDORS
Click to expand...
INNER JOIN (PURCHREQ
INNER JOIN PO ON PURCHREQ.PRNUM = PO.PRNUM)
ON VENDORS.VENDORID = PURCHREQ.VENDORID)
INNER JOIN Users
ON PURCHREQ.REQUESTEDBY = Users.EmployeeID)
INNER JOIN GLNUMBERS
ON PURCHREQ.GLNUM = GLNUMBERS.GLNUM)
INNER JOIN PRTOTAL
ON PURCHREQ.PRNUM = PRTOTAL.PRNUM)
INNER JOIN TyrexShippingLocations
ON PO.SHIPTO = TyrexShippingLocations.SLOCATIONID)
INNER JOIN TyrexBillingLocations
ON PO.BILLTO = TyrexBillingLocations.BLOCATIONID


I suspect that at least one of thoses table is where the
extra records for a PO.

Make a copy of the query to play around with. Then try
removing one table to see if the "duplicate" records are
eliminated. If they are, then think about your reason for
using that table. If the suplicates remain, go bak to a
fresh copy of the query and remove a different table and
repeat the test.

Somewhere along the way, you should find something you have
not considered in your query design (e.g. one PO can link to
multiple prtotals)
 
Thank you so much. I will give this a try and let you how it turns out

Marshall Barton said:
rludden wrote:

[snip select clause]
FROM (((((VENDORS
Click to expand...
INNER JOIN (PURCHREQ
INNER JOIN PO ON PURCHREQ.PRNUM = PO.PRNUM)
ON VENDORS.VENDORID = PURCHREQ.VENDORID)
INNER JOIN Users
ON PURCHREQ.REQUESTEDBY = Users.EmployeeID)
INNER JOIN GLNUMBERS
ON PURCHREQ.GLNUM = GLNUMBERS.GLNUM)
INNER JOIN PRTOTAL
ON PURCHREQ.PRNUM = PRTOTAL.PRNUM)
INNER JOIN TyrexShippingLocations
ON PO.SHIPTO = TyrexShippingLocations.SLOCATIONID)
INNER JOIN TyrexBillingLocations
ON PO.BILLTO = TyrexBillingLocations.BLOCATIONID


I suspect that at least one of thoses table is where the
extra records for a PO.

Make a copy of the query to play around with. Then try
removing one table to see if the "duplicate" records are
eliminated. If they are, then think about your reason for
using that table. If the suplicates remain, go bak to a
fresh copy of the query and remove a different table and
repeat the test.

Somewhere along the way, you should find something you have
not considered in your query design (e.g. one PO can link to
multiple prtotals)
Click to expand...
 
Back
Top