I have a report whose Source = 2 tables in a query where they share a common field: "Order Number". There is a 3rd table that adds the package size information. The Report is set up shows the product that is being ordered at the bottom and a third table shows the shipping dimensions of the package and contains the Pallet number. The pallet number is staged to the PO number and tied to the financial side. So, where I have 2 unique entries in 2 different tables, I end up with duplicate listings of the product and lot. I even checked the "Unique Value" in the Query/Properties window and that didn't stop it. Any suggestions?
duplicate records in report due to multiple subtables....
- Thread starter QMDirk
- Start date
You posted in the Forms section, talk about a Report, but from what I see the real issue is a query. Queries are where you get the data, reports are really just formatting. Since you are having issues with the correct data, let's talk in terms of tables and queries.
Can you post sample data? Please provide 2 sets of data to demonstrate what you have in your tables and what your query should produce:
A. Starting data from your table(s). Include tab le and field names and enough data to cover all cases.
B. Expected results of A. Show what data you expect your query to produce when you feed in the data from A.
Again, 2 sets of data--starting and expected results.
Can you post sample data? Please provide 2 sets of data to demonstrate what you have in your tables and what your query should produce:
A. Starting data from your table(s). Include tab le and field names and enough data to cover all cases.
B. Expected results of A. Show what data you expect your query to produce when you feed in the data from A.
Again, 2 sets of data--starting and expected results.
sorry for posting in the wrong forum, I try to be more aware of that. I think you're right though, because when I just run the report, it shows just the 2 entries from the table. But I have a button setup to run the report for the specified record, attach it to an email, and send it to the person who will input the order into system to generate an invoice. It's imperative that my report is accurate, so, for now I'm just explaining to them to watch for duplicate entries. I'd rather fix it properly though. I'll get some more data and post it tomorrow. Thanks.
Similar threads
