G
Guest
I used the following to get the last record from a query. I want to get the
last record entered by date. I do not get the last record.
I used this in the FIELD query grid --
X: DatePart("yyyy",[YourDateField])&DatePart("m",[YourDateField])
I used this as Criteria in the query grid --
DatePart("yyyy",Date()-Day(Date()))&DatePart("m",Date()-Day(Date()))
Pleae help!
last record entered by date. I do not get the last record.
I used this in the FIELD query grid --
X: DatePart("yyyy",[YourDateField])&DatePart("m",[YourDateField])
I used this as Criteria in the query grid --
DatePart("yyyy",Date()-Day(Date()))&DatePart("m",Date()-Day(Date()))
Pleae help!