MIN and MAX Date Formula in a report

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max and Min will not display correctly 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Max of multiple fields 1
trying to sum a group of records but "sum" missing from Group, Sort, and Total dropdown/wizard 8
Chart data using Access 1
Min and Max for Date Range in Report 4
Counting Number of Min/Max Instances 4
Sorting based on a max function in a subreport (in Access 2003) 3

Top