R
rludden
How do i get the report to print only one. it does show as a duplicate in my
queries, but not in the tables.
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.
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.
rludden said:Would you tell me how to find the SQL to copy and paste?
INNER JOIN (PURCHREQFROM (((((VENDORS
Marshall Barton said:rludden wrote:
[snip select clause]INNER JOIN (PURCHREQFROM (((((VENDORS
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)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.