converting date to numeric

how can I convert a date field to the unique sequential
numeric number the computer assigns to each day(my
understanding is the computer automatically assigns a
unique sequential number)

Perhaps, it is better to post follow-up questions / clarifications in your
original thread(s) where respondents have attempted to answer your question
rather than posting a new thread.

With the original thread(s) where potential respondents can see the previous
attempted answers and won't offer the same attempts.

For your info., each date value in JET / Access / VB is a number represent
the number of days prior to / since 30/12/1899 (this is day zero). Since it
is already numeric, you don't have to "convert" a date value to numeric. It
is also unique for each day (in the valid range of date values) and
sequential (today = yesterday + 1, tomorrow = today + 1).

You may like to clarify what you want in the original thread ...

--
HTH
Van T. Dinh
MVP (Access)


"janecline" wrote in message
...
how can I convert a date field to the unique sequential
numeric number the computer assigns to each day(my
understanding is the computer automatically assigns a
unique sequential number)