Dfirst and DLast function

[kft10 via AccessMonster.com]

Hi,

Can anyone tell me how to get the first and the last record on field 'date'
of my table 'table1'? I can't find it in help menu in my Access. Thank you
in advance.

KF

 

[Allen Browne]

Can anyone tell me how to get the first and the last record on field
'date'
of my table 'table1'? I can't find it in help menu in my Access. Thank
you
in advance.

Use DMin() and DMax()

If you want to get to other fields in that record too, see:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

 

[kft10 via AccessMonster.com]

I got you. Thank you very much.

Use DMin() and DMax()

If you want to get to other fields in that record too, see:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm