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.
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.
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.