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
cssc1Asked:
Who is Participating?
 
als315Commented:
You have an error in field names:
=[Total Minutes]*[Average Flow Rate]
should be:
=[Total Sampling Time in Minutes]*[Average Flow Rate (Start Flow Rate X End Flow Rate)]
Silica_App---V4.accdb
0
 
cssc1Author Commented:
Sorry, to get to the proper screen just open the app and click the button "Sampling Setup" and scroll to the bottom
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
in a query, you can use a calculated fieldname in another expression (as you know, since you do this). On a form, however, you cannot generally use a calculated controlname in another control source; you need to repeat the equation. Therefore, this:
=[Total Minutes]*[Average Flow Rate]
needs to change

given that:
[Total Minutes] =DateDiff("n",[Sampling Start Time],[Sampling End time])
and
[Average Flow Rate] contains [RoundFlowRate2]

then try:

=DateDiff("n",[Sampling Start Time],[Sampling End time]) * [RoundFlowRate2]

you could also put this formula in the form record source.
0
 
cssc1Author Commented:
Thank you both for the hep
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help

~crystal
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.