duplicate problem

[RuralGuy]

It is easy to change a control name on a report. Are you having a problem?

[hokie]

I am running into a problem with the code. On my report I do not need the invoice numbers included only a total of all the freight as 1 field, handling as another field, Total as another field, and Monogramming as the other on the report that is divided based on the Company name. I think I am running into the problem because of the way my report was running. I have a query that matches a unique order number between 2 tables. I then have a query off of this previous query that uses the Totals button to sum the Total and Monogramming field. This worked until I added these two new txtFreight and txtHandling. Adding these to the query tries to add a group by to these fields which messes up the original report. I apologize if this has gotten a little too complicated because of my lack of knowledge. If this is too complicated for a forum it is no big deal we can get around this freight and handling piece by manually looking the current database. Just thought there was a way to add the automation for this piece also. They are a small piece as the program is done except for these last 2 pieces.

[RuralGuy]

I had suggested renaming the controls on your report, not the fields in your query.

[hokie]

Sorry I do not know how to rename the controls on my report.

[RuralGuy]

With the report in design view, right click on a control and go to properties and then the Other tab. The name of the control is the first row on that tab.

[hokie]

Ok sorry for the confusion but I'm missing something here. The query this report is based on does not work as intended when I add the InvoiceNumber, Freight, and Handling. It tries to apply the group by to them which messes up the way the report was running. Before there was 1 page for each Different company name. now there are several because the different invoice numbers create extra rows in the query. Before I just had SumofTotal and SumofOcost on the report. I couldn't run the same sum function because of the initial problem...

Thanks for all the help

[hokie]

So if i leave the Freight, Handling, and InvoiceNumber off of the query the report is based off of I don't see how I can add it to the report to change the control name. But if I add them to the query it messes the query results up. Am I making sense here?

[RuralGuy]

So you need the duplicate values removed long before you get to the report right? I don't know if that can be accomplished without making a new table.

[hokie]

I'm thinking you might need me to use the report instead of my 2nd query that sums up the SumofTotal and SumofOCOST but I now run into the problem where I need it grouped based on the Company name. Because there are multiple invoice numbers for each Company name it is not summarizing in the way I was looking for.

[hokie]

Yes ideally these values would be removed before the report is run.

[RuralGuy]

Why not store the "imported" data in a Temp table and operate on the table before using it in your queries?

[hokie]

I think that will be the best solution. Thanks for the fast help!

[RuralGuy]

Post back in this thread if you are still having trouble.