An expression to create a sequential number field based on date (1 Viewer)

[tmort]

I would like to creates some queries that subtract the value from one day to the next. Not every day will have a value so it looks way to do this is with a sequential number field based on the date. I thought the way to do it was with the autonumber fields but not all of the values will necessarily be entered sequentially.

I'm thinking of some sort of query to sort by date and then with an expression to add sequencial numbers to another field.

Any ideas?

Thanks in advance

 

[llkhoutx]

Date is a number. Hours, minutes and seconds aare the fractional part. Therefore, is the fractional part of the date s being used, convert the date to long integer. Start your autonumber index with a long integer (date) value.

 

[The_Doc_Man]

More specifically,

loSeqNo = CLng( dtDateTime )

where

Dim dtDateTime As Date

In case you were wondering, the number you get is the integer number of days since the date reference = 1 - Jan - 1900 @ 00:00
or something close to that.

 

[tmort]

Sequential numbers in query

The values I have don't include time so that won't work, plus I don't know VB.

I found a function at www.lebans.com that creates sequential numbers in queries and forms.

I'm attaching a db with the function.

I'm also attaching a simple db in which I try to use it to no avail.

I copied the code from the example db and pasted it into the test db and also saved the code as a bas file and then imported it into the test db and called it in a query. I get an error both ways.

Can someone see what I am doing wrong. I know it works because the example works.

Thanks in advance

 

[tmort]

Sequential numbers

Here is the other file that isn't working that I reffered to