By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

Report Doubling information but not doubled in table

P: 1
I have a table that a report is run from. It does not contain duplicate information although the report is doubling it. PLEASE HELP!!
Dec 4 '13 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397

Hold it............ a little longer..... just a little more...


More than likely this has to do with the query that your report is based on.

Please do the following:
Open the report in Design View.
Right click and in the pop-up select "properties" (usually at the bottom)
When the properties sheet opens, there will be a dropdown list at the top of it, select "Report"
Click on the "Data" tab
Make note of the entry in the "Record Source"
If this is something like: "Select * From tablenamehere..."
then you will need to get that entire string - let us know.

More likely you have something like "qryforreport" or "tblone" once you have the name written down, you can close the report editor.

You now need to locate the query or table that is the record source for your report.

You should not have a query and a table with the same name... if you do, let us know!

If the record source is actually the table directly, then we'll need to know that so that we can play the 20-Question's game (-_).

If you find that this is a query, then, first, just open the query... you might be surprised at what is returned. Let us know too.
Now open the query in design mode.
In the upper section where the tables are shown, right click, and select SQL-view
Copy that
Come here
Press the [CODE/] format button it will place two code tags in the message, paste the SQL-text you copied between the two tags.

Well bring out the big hammers and pound on it (^_^)

Dec 4 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.