showing the first date of many

[access my brain]

I have a form with several 'start' and 'end' date fields on it. I'd like to add another field which looks at all the start fields and gives the 'earliest date' record and also for the lastest date.

this is a probably a really easy question but i'm getting nowhere
:-(

any help much appreciated

 

[Mile-O]

As the ControlSource of a textbox where StartDate is a field in the form's underlying recordsource...

=Min([StartDate])

 

[namliam]

That is if you have 1 field in table view

If you have many fields in 1 records you can delimit it...

Min(Field1;Field2;...) [maybe replace ; by ,]

Do the reverse with Max...

Regards

 

[access my brain]

When I try the following I still get an error message

=Min(ukstart,italystart)

"The expression has invalid syntax, you may have entered an operand without an operator"

also tried

=Min([ukstart],[italystart]) and semi-colon as well

 

[namliam]

Try looking at the help... My Access is busted at the moment so cant do it for you sorry...

Regards

 

[access my brain]

thank you for your help I will keep trying

 

[namliam]

Well was unable to workout the max as well so i tryed another approach...

i have this table

Date1    Date2    Date3    UID
1-1-2003 3-1-2003 2-1-2003 1
2-2-2003 5-2-2003 1-2-2003 2

Table name: Table2
And running this query:

SELECT UID as ID, Max(MyDate) AS MaxOfMyDate
FROM [SELECT Table2.UID as UID, Table2.Date1 as MyDate FROM Table2
union
SELECT Table2.UID, Table2.Date2 FROM Table2
union 
SELECT Table2.UID, Table2.Date3 FROM Table2]. AS [GreatUnion]
GROUP BY UID;

Returnes:

ID	MaxOfMyDate
1	3-1-2003
2	5-2-2003

I hope this is what your wanting to do...

Regards

The Mailman