Access Report Problem, need help please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that has a few calculations involved and one has me stumped.

I have in my DB a TIme In and TIme Out field, these fields are of a
TIME/DATE format. In the report I calculated an Elapsed Time output between
the two. Input/Output looks like the following

Input: Time In 12:00 pm
Time Out 2:30 pm

Output: 2 Hours 30 minutes

I want to take this output and multiply it by a Delivery Charge, but I don't
know how to program individual pieces of the out put, meaning how can I just
have it multiply.

Assistance is most appreciated, just started using access and havign a bitof
a rough go at it.
 
You MULTIPLY by a delivery charge?

Just use your same formula that you used to calculate the difference and add
*[DeliveryChargeName] to it.

For example....



SomeFieldName = DateDiff("n", StartTime, EndTime) * [DeliveryCharge]


You'd have to give us more details if this is not what you are asking.
 
Back
Top