This should be simple, but I'm going round in circles!
We have a table (tblResults) that contains a time field (Tm) that is stored in the format dd/mm/yyyy hh:mm:ss This table also contains a long numeric field (Tp)
I'm now trying to load up a second table with the daily maximums, where the date format is dd/mm/yyyy
So, I've tried things like this ... trying to tie the formats together:
Dim criteria
criteria = "format(Tm," & """dd\/mm\/yyyy""" & ") = " & [checkday]
.
.
With data
.AddNew
!dateline = [checkday]
!max = DMax("Tp", "tblResults", [criteria])
.
.
But it doesn't work!
Any clues please?
Start Free Trial
