Default earliest date and latest

[Compufreak]

Hi



i have did some research with regards to this

i would like for my report for default to the earliest and latest date ,should the user not select a start date and end date.

i have read about using MIN and MAX , but i am not sure how this would work.

please help

[orange]

Google ms access min max functions techonthenet for a dscription of the functions and sample usage

[Compufreak]

If IsNull(Combo1.Value) And (([StartDate] <> " ") Or ([EndDate] <> " ")) And IsNull(Combo53.Value) Then
                
                   strSQL = strSQL & " " & "WHERE [Day_Month_Year] Between #" & [StartDate] & "# AND #" & [EndDate] & "#" & ";"

N.B: Above code is in vba

i would just like to know , how will i be able to pull the minimum and maximum dates if the user does not select any from the form.

also i am displaying the dates on the report , it works fine when i select a date .... but i am just puzzled by this MIN and MAX functionality.

i know its simple as i can't seem to find a proper solution that will help.

thanks again for the assistance

[orange]

Google Dmin and Dmax functions and examples

http://www.techonthenet.com/access/f...omain/dmax.php