I need to create a field to calculate how many days have elapsed since a
particular date.

Any ideas?

"Karen Williams" <Karen (E-Mail Removed)> wrote in message
news:7D428B98-F3F7-4E5E-B148-(E-Mail Removed)...
> I need to create a field to calculate how many days have elapsed since a
> particular date.
>
> Any ideas?

Javascript, ASP, or some other scripting language.

Search the net, that type of thing may already exist.

If you want to know how many days have elapsed from some date that is in
a date field of an Access database (for example how may days ago did
someon sign up), you can easiliy make a query that will provide that
for every entry in the database).

All you have to do in the query builder is type in the expression:

DaysSinceSignup: Date()-[signupdate]

where in this example the query field name is DaysSinceSignup and the
sinupdate is the field from which you are counting the dates.

Of course you need to have brought the appropriate fields from your
table into the query.

Karen Williams wrote:

>I need to create a field to calculate how many days have elapsed since a
>particular date.
>
>Any ideas?
>
>