date function?

[jlnewbie]

I need a date function that will give me from my query the earliest to last date across the domain. I then plan to concatenate the following statement "From Date1 through Date2"

thank you

JLopez
Lopez31@ATC-Enviro.com
Environmental Services @ Your Service

 

[jebry]

Hi JLopez!

Try the DMax and DMin functions in general it is formatted like this:

D___("YourField", "YourDomain", "YourCriteria&quot

The criteria is optional.

hth
Jeff Bridgham
bridgham@purdue.edu