Prev: Form Control Default property problem
Next: Form to look for similar addresses
From: kft10 via AccessMonster.com on 10 Oct 2008 10:29
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200810/1

From: Allen Browne on 10 Oct 2008 11:21
"kft10 via AccessMonster.com" <u45012(a)uwe> wrote in message
news:8b75ed481515a(a)uwe...
>
> 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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

From: kft10 via AccessMonster.com on 14 Oct 2008 11:01
I got you. Thank you very much.

Allen Browne wrote:
>> 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
>

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200810/1

 | 
Pages: 1
Prev: Form Control Default property problem
Next: Form to look for similar addresses