Results 1 to 14 of 14
  1. #1
    ads8525 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    8

    Deleting rows


    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?

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    "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.

  3. #3
    ads8525 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    8
    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?

  4. #4
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    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?

  5. #5
    ads8525 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    8
    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?

  6. #6
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    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.

  7. #7
    ads8525 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    8
    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

  8. #8
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    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?

  9. #9
    ads8525 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    8
    15 pages of prices for different products whites, blacks, reds and so on.

  10. #10
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    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.

  11. #11
    ads8525 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    8
    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.

  12. #12
    ads8525 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    8
    Hopefully this show you a little more.

  13. #13
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    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!

  14. #14
    ads8525 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    8
    I will have top keep playing with it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Deleting Folders
    By Madmax in forum Access
    Replies: 1
    Last Post: 10-05-2011, 11:02 AM
  2. Replies: 2
    Last Post: 08-28-2011, 06:06 AM
  3. Replies: 11
    Last Post: 12-14-2010, 01:25 PM
  4. deleting records
    By radicalrik in forum Queries
    Replies: 2
    Last Post: 07-14-2010, 03:10 PM
  5. Deleting certain data
    By swindmiller in forum Queries
    Replies: 3
    Last Post: 02-17-2010, 10:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums