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" <ivpfmc28@yahoo.com> wrote in message
news:8a5e9892.0403062255.4fb3b2a3@posting.google.c om...[color=blue]
> 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.[/color]
