I am creating a database that logs all the internet usage in the company. One field shows the time that the people are on each site. I need to perform a calculation that will take earliest time and the latest time and then tell me how long they were on. I need this because people can be on several different sites in one second, so a person could be on for only a couple of minutes but there could be 50 pages of data. All I need to know is how long they are on. Please send suggestions.

assuming that you have both fields formatted to date/time you can just use the fomula:

[Field1]-[Field2]

this will return the difference in the 2 times.

If there are several log on / log off times per person, you need to make serveral calulations (one per log on) and then sum all the times

The problem is that the times are all in one field. So I can't use [Field1]-[Field2]. Is there a way to do this in one field?

send me a copy of the dbf and I will have a quick look... I can't picture what you are saying...

andy.hartley@valeo.com

Dear Andy Hartley,

I noticed your helpful reply to this individual, and wonder if you can assist me too - I have a similar query.

I will be posting a similar query under the heading "Getting Access to auto insert a data in a report". Can you assist me?

Kind Regards,
Jay/UK