MIN and MAX Date Formula in a report

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

In my report based on a Table I am trying to display MIN
and Max dates (eg From: Sept 1, 2003 To: Sept 8, 2003)in
two seperate fields.

The field in my Table is called "DRWDATE"

In the control source field on my report I have been trying

=MIN([DRWDATE]) for one field and =MAX([DRWDATE]) for the
other

I'm doing something wrong obviously

Thanks for any help
 
Ron said:
In my report based on a Table I am trying to display MIN
and Max dates (eg From: Sept 1, 2003 To: Sept 8, 2003)in
two seperate fields.

The field in my Table is called "DRWDATE"

In the control source field on my report I have been trying

=MIN([DRWDATE]) for one field and =MAX([DRWDATE]) for the
other
Click to expand...


You really should tell us what went wrong. One common
mistake is trying to place those text boxes in a page header
or footer section, which is not allowed.
 
Back
Top