By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,071 Members | 1,244 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,071 IT Pros & Developers. It's quick & easy.

highest and lowest date

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.