I am an access newbie and have been having a bit of trouble trying to get this code right.
I have one minute intervals between records, so I would like to have the start time from one record be transferred to the start time of the next record plus one minute.
I have been using the dlookup function to transfer all the information I need from one record to the next but cant seem to get the code right on how to add on the minute.
My code so far is:
Expand|Select|Wrap|Line Numbers
- Dim ID As Long
- ID = DMax("Focal_ID", "OnshoreFocal")
- DoCmd.GoToRecord , , acNewRec
- Date = DLookup("Date", "OnshoreFocal", "Focal_ID=" & ID)
- Start = DLookup("Start", "OnshoreFocal", "Focal_ID=" & ID)
- Format = DateAdd ("n",1,Start)
All help greatly appreciated
TIA
Cath