Calculated field question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Neil Grantham" <neil40@xxxxxxxxxxxxxx>
Date: 22 Dec 2005 17:46:07 -0800

I have a table that is a list of results (1st to 10th) for various
events.

Each line in the table has an event code, so that they get grouped
correctly on a report (page per event)

Each comptitor has a finishing time recorded.

In my report, I would like to show the time difference from the
previous competitor.
I believe the best way is not to store calc's in the table, so how
would I calculate this in a query?

Thanks and Merry Christmas
Neil

.

Follow-Ups:
- Re: Calculated field question
  - From: Allen Browne

Prev by Date: Re: Displaying Image (OLE Object)
Next by Date: Re: Calculated field question
Previous by thread: Re: help in calculation
Next by thread: Re: Calculated field question
Index(es):
- Date
- Thread

Relevant Pages

Re: calculate accumulated
... Would not have it unites function where I can store the previous value and ... > Calculation in report event code is always problematical, ... This is particularly a problem if you are in Report ... > I strongly recommend you do your calculations in the query on which the ...
(microsoft.public.access.forms)
Re: calculate accumulated
... Would not have it unites function where I can store the previous value and ... > Calculation in report event code is always problematical, ... This is particularly a problem if you are in Report ... > I strongly recommend you do your calculations in the query on which the ...
(microsoft.public.access.reports)
Re: calculate accumulated
... Calculation in report event code is always problematical, ... This is particularly a problem if you are in Report ... I strongly recommend you do your calculations in the query on which the ... or the Running Sum property. ...
(microsoft.public.access.forms)
Re: calculate accumulated
... Calculation in report event code is always problematical, ... This is particularly a problem if you are in Report ... I strongly recommend you do your calculations in the query on which the ... or the Running Sum property. ...
(microsoft.public.access.reports)
Re: Unbound fields wont print
... Are those calculations in event code? ... I'm not a 'fan' of printing forms; I'd rather "Save as Report", ... All the other text boxes are filled via VBA ...
(microsoft.public.access.formscoding)