Access Report Problem, need help please

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Relevant Pages

  • Re: Suggestions Please
    ... I will use a Create Query each time the report is run to generate new values from my Function DoCalc. ... Dim intColWidth As Integer ... Dim intRow As Integer ... Is there code outside the Function that needs to be placed somewhere to "count" the number of calculations? ...
    (microsoft.public.access.reports)
  • RE: Auto run excel calculations in background - Help!
    ... A standard module is one of those you will see when you select Modules from ... specific to a form or report. ... calculations one time and then use that data in multiple ways, ... of columns in an Excel Spreadsheet. ...
    (microsoft.public.access.externaldata)
  • Re: Do these calculated fields warrant table storage?
    ... Don't store the calculations. ... Each sales and royalty report goes into a record. ... Franchise Identifier is an attribute of that record (Probably as a ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Excel VBA - Compressing a Workbook
    ... Dim SH As Worksheet ... >> Currently, I run an automated daily report, that is started up by ... >> and spits out an Excel Spreadsheet based on some comparison numbers. ... >> Excel do all of the percentage calculations etc etc and just throwing out ...
    (microsoft.public.excel.programming)
  • Re: log total hour for the day and hours used for each task
    ... deal of work to do before you design / implement a report. ... Here are a few general hints for the kinds of calculations you describe ... Elapsed time between two date/times is calculated using the DateDiff ... might be Long Integer or Single- or Double-precision Floating Point. ...
    (microsoft.public.access.reports)