Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. secelec

    Time Issue - Can't Total Times

    Hi Tried this and learned a lot new. What I'm finding now is that it seems to be summing the number of records in the group, rather than calculating the total of the times inserted by the formula {@Time on site} which is now returning a value in seconds - e.g. if time on says 08:06:55 and Time...
  2. secelec

    Time Issue - Can't Total Times

    Hi again - sorry for the delay in getting back to this one. I'm trying to get to grips with precisely what you mean by your terminology of format and data types - but here's what I think you mean: In my report, I have three groups on which the report is sorted: By Department By Date...
  3. secelec

    Time Issue - Can't Total Times

    Ah, OK. Sorry. Only just joined, and I wasn't sure how much info would be wanted...... I did put the version number in - 9. (Prof). I'm connecting to an Access (2003) DB built specifically to take data out of an Access control program, and query the tables for the information needed. The...
  4. secelec

    Time Issue - Can't Total Times

    Hi CR9. I have fields "On" and "Off" which are time fields, and on each rowset a formula totals the time between the two - as per a timesheet, for example. What I need to achieve is to total the times generated by my @Day Total formula for each weekly period. I've tried all variations of the...

Part and Inventory Search

Back
Top