DMAX and DMIN

  • Thread starter Thread starter SAM
  • Start date Start date
S

SAM

I need some help with what each part of the expression
that follows the DMAX and DMIN function mean.
My DMIN is the start of an aircraft "HOBBS" meter reading
for the beginning of the month and the DMAX is the
ending "HOBBS reading. for the end of the month. There is
a beginning and an ending for each day the aircraft flys
but I want to print a report with a date range of the
beginning of the month to the end of the month and I need
the lowest reading in the date range and the highest
reading in the date range
This is the expression but I don't know that each section
means DMin («expr», «domain», «criteria»)
Thanks
SAM
 
<<expr>> usually refers to the Field you want to DMin
<<domain>> refers to the table or query
<<criteria>> defines the conditions that must be met. This is a WHERE
expression without use the word 'Where'. If you want to find the DMin
across the entire table, you can leave it blank. Otherwise you need to tell
it which group of rows you want to find the min of.

It could be something like this
"[User] = 'Sam'"

More likely, it you want to find all rows in the current or past month. But
without knowing more about your table and the conditions that must be met, I
can't say more.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org


I need some help with what each part of the expression
that follows the DMAX and DMIN function mean.
My DMIN is the start of an aircraft "HOBBS" meter reading
for the beginning of the month and the DMAX is the
ending "HOBBS reading. for the end of the month. There is
a beginning and an ending for each day the aircraft flys
but I want to print a report with a date range of the
beginning of the month to the end of the month and I need
the lowest reading in the date range and the highest
reading in the date range
This is the expression but I don't know that each section
means DMin («expr», «domain», «criteria»)
Thanks
SAM
 
Back
Top