468,285 Members | 1,534 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,285 developers. It's quick & easy.

highest and lowest date

hi guys,
im still a newbie in ms-access and i would like to ask how can i
get the highest and the lowest date in ms-access report? for example,
i have these entries:
10/1/2003
10/5/2003
10/2/2003
10/4/2003
10/2/2003
10/3/2003
10/3/2003
what i want to do is to print the highest and the lowest date like
this:
Oct 1, 2003 - Oct 5, 2003. how will i do this this? can somebody
help me? your immediate response is very much appreciated.
Nov 12 '05 #1
2 2856
On 6 Mar 2004 22:55:48 -0800, nick_faye wrote:
hi guys,
im still a newbie in ms-access and i would like to ask how can i
get the highest and the lowest date in ms-access report? for example,
i have these entries:
10/1/2003
10/5/2003
10/2/2003
10/4/2003
10/2/2003
10/3/2003
10/3/2003
what i want to do is to print the highest and the lowest date like
this:
Oct 1, 2003 - Oct 5, 2003. how will i do this this? can somebody
help me? your immediate response is very much appreciated.


In a report control's control source:
=Min([DateField]) & " - " & Max([DateField])

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #2
Create a query into this table.

Depress the Total button on the toolbar (Upper sigma icon).
Access adds a Total row to the query.

Drag the date field into the query Twice.
In the Total row, under the first one choose Min, and the 2nd one Max.

Use this query as the source for your report.

Alternatively, you could place text boxes on your report, with ControlSource
set to:
=DMin("MyDateField", "MyTable")
and
=DMax("MyDateField", "MyTable")

--
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.

"nick_faye" <iv******@yahoo.com> wrote in message
news:8a**************************@posting.google.c om...
hi guys,
im still a newbie in ms-access and i would like to ask how can i
get the highest and the lowest date in ms-access report? for example,
i have these entries:
10/1/2003
10/5/2003
10/2/2003
10/4/2003
10/2/2003
10/3/2003
10/3/2003
what i want to do is to print the highest and the lowest date like
this:
Oct 1, 2003 - Oct 5, 2003. how will i do this this? can somebody
help me? your immediate response is very much appreciated.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

21 posts views Thread by Jaspreet | last post: by
17 posts views Thread by rhitz1218 | last post: by
3 posts views Thread by =?Utf-8?B?cm9kY2hhcg==?= | last post: by
reply views Thread by NPC403 | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.