I have attached a report that I designed for pricing but I need to delete some rows so I can get all my pricing on one row. How can I do this?
I have attached a report that I designed for pricing but I need to delete some rows so I can get all my pricing on one row. How can I do this?
"Delete" is the wrong word - that would remove the data from the database permanently which I don't think you want. Change the record source of your report to be a Totals query - to do this go into query design and click on the "E" icon. It will give you another row to fill in at the bottom. You want to Group By Category and sum your amounts.
You are correct it has been deleting my info, not what I want. I got the additional row for total but when I sum it adds everything in the column together, not really what I am looking for. What am I doing wrong?
I guess your data doesn't match the screen print you attached above. There it shows only one total for each column, so summing it all together made no difference. What exactly are you trying to achieve?
In the attached report there is one product available in 4 or 5 quantities with each quantity having a different price. I would like the report to have the item once with all the different prices on the same row under each different heading that corresponds to the price. Does that make sense?
Is "WhiteXXX" the product? Your report is showing a number under Quart, etc. - is that the different price per quantity?
If that is the case then I don't understand what your query would be summing when you say it is summing "everything". Your report above is only showing one price for Quart, etc.
Yes...
I109024A is item number
White XXX is product name
The number under quart is price, but what you are seeing is only part of the pricelist. The pricelist is 15 pages or so and when I sum it adds all the other prices in the same column together. Can you tell I a newbie
There are 15 pages of White XXX prices? Why is there more than one price per product per column, what is differentiating one from another?
15 pages of prices for different products whites, blacks, reds and so on.
If your query does a Group By product, that should give you one price per column, whether you sum it or not.
If you wish you can attach your database and I will look at it closer.
My query does group by product but becuase of the way our database is designed it puts the price on different rows for each quantity.
Hopefully this show you a little more.
No, doesn't show me any more - just more of the same.
If you group by "White Brite HO LB" then there will only be one row for it. That's what Group By is designed to do. Try a new query, select the products and categories and leave out the prices for now. See if you can't get the query to give one line per product. Then you can add the price fields to the query and sum them and see if it is still giving you one line per product. Don't worry about the report for now, get the query working and then the rest will be easy!
I will have top keep playing with it.