Results 1 to 2 of 2
  1. #1
    samos1023 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2017
    Posts
    18

    quote report group and count like products

    Ok so I have a database for quoting items. I have a tblQuote and a tblQuoteItems. I created a form that allows me to add a quote to the tblquote and items to the tblQuoteitems. This all works great. When I print out a report of of the records in tblQuoteItems for a particular quoteID. This works great too. What I want to do is evaluate the items in tblQuoteItems and total up any the items

    example currently my subform shows as an example"

    Name Desc Cost


    Product A a desc about me 50.00
    Product A a desc about me 50.00
    Product A a desc about me 50.00
    Product B a desc about me 25.00
    Product B a desc about me 25.00

    what I want to show
    Name Desc Cost Quantity Ext Cost
    Product A a desc about me 50.00 3 150
    Product B a desc about me 25.00 2 50

    I cant change the tblQuoteItems to the format needed because each item may have data tagged to them(SN,PO etc). I just need to summarize it for the report that prints out. Any ideas? Thanks in advance.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Name Desc Cost
    Product A a desc about me 50.00
    Product A a desc about me 50.00
    Product A a desc about me 50.00
    Product B a desc about me 25.00
    Product B a desc about me 25.00

    group by COST field , with Footer showing,

    add txtCost as field of =Cost,
    put textbox txtCount as =Count(Cost),
    the last text box calcs the ExtCost
    (put these in the group footer)

    CostFooter:
    txtProduct , txtDesc, txtCost, txtCount, =txtCost*txtCount

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

Similar Threads

  1. Replies: 2
    Last Post: 11-26-2016, 01:07 PM
  2. Replies: 4
    Last Post: 07-24-2013, 02:34 PM
  3. Replies: 7
    Last Post: 06-04-2013, 11:14 AM
  4. COUNT Group Count Records COUNT FUNCTION
    By PMCOFFEY in forum Access
    Replies: 9
    Last Post: 11-09-2012, 09:40 PM
  5. Replies: 8
    Last Post: 04-24-2012, 01:05 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