Link to home
Start Free TrialLog in
Avatar of cssc1
cssc1Flag for United States of America

asked on

What is the MS Access formula, function or query to multiply two fields that works?

PROBLEM
I can’t figure out a formula or function or query to calculate the Volume of Liters which is calculated by:
Total Minutes X Average flow rate
See image attached. The two fields used to multiply the Total Minutes by the Average Flow Rate have a red box around them.
multiplication-Problem.jpg
Silica_App---V4.accdb
Avatar of cssc1
cssc1
Flag of United States of America image

ASKER

Sorry, to get to the proper screen just open the app and click the button "Sampling Setup" and scroll to the bottom
SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cssc1

ASKER

Thank you both for the hep
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

you're welcome ~ happy to help

~crystal