Results 1 to 2 of 2
  1. #1
    binaryve is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2014
    Posts
    1

    product of a query

    Hello all,

    This should be easy but I cant figure it out

    I have a query that results in a field of numbers.
    I have a second query where I want to get the product of those numbers

    Group by has no product option
    not sure how to proceed.



    Thanks
    T.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Probably require VBA code that opens a recordset object and cycles through the records.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 4
    Last Post: 04-26-2013, 08:32 AM
  2. Replies: 3
    Last Post: 02-26-2013, 05:07 AM
  3. product hierarchy
    By Lata in forum Access
    Replies: 13
    Last Post: 08-03-2011, 02:56 AM
  4. advanced product attachment query
    By therzakid in forum Queries
    Replies: 1
    Last Post: 07-29-2011, 11:53 PM
  5. Product in a Summary Query
    By Fletch in forum Queries
    Replies: 0
    Last Post: 12-11-2008, 03:14 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