Code:
Time_Next: DMin("Timestamp","W_Table","[ID] >" & [ID])
skyguy
Last Activity: Apr 28 '15, 10:42 PM
Joined: Apr 26 '15
Location:
-
Hi jforbes, I was trying to implement this in a query. The following code worked perfectly, and doesn't require sequential IDs:
Thank you very much for your input! -
Report next value in sequence to current record
[[Split from: Row-Numbering a Query based on Date Values ]]
Thank you so much Luuk! Very helpful!
Could you help me with one more thing? Now that the rows have sequential IDs, how could I create a field that lists the timestamp in the very next row in each row? For example, I would like to have the following:
...Code:Lot Status Timestamp Next_Timestamp 342 Down 4/25/2015 6:49:00 AM
-
Row-Numbering a Query based on Date Values
Hi,
My query contains three fields: Lot, Status, and Timestamp. I've sorted the query by ascending Timestamp values and would like to assign a row number ID to each row. I've tried using:
ID: DCount("Timesta mp","Weighing", "[Timestamp] <=" & [Timestamp])
but Access keeps returning errors and tells me that I have a syntax error. Is this because my DCount criteria involves...
No activity results to display
Leave a comment: