DMin Function

[AuditorCMM]

I have a database that is used to log employee compliants. A query (Details
Qry) is used to summarize all of the compliants within a specified date range
that is entered by the user. I am trying to put together a report that
includes a field that identifies the oldest report still under investigation.
I tried using the following DMin function, but I keep getting an error:

=DMin("[Date of Incident]","Details Qry"," [Action Taken]='Investigation in
Process'")

If I use the same function based on the original table, it works, but not on
the query. Does the above function not work when you are entering your own
date range? Any help would be appreciated. Thanks!

 

[George Nicholson]

Might have been helpful to know what the error was...

Did the original table have a space in its name too? The only suggestion I
have is to reference "[Details Query]" (with brackets) since the object name
has a space in it.

HTH,

 

[AuditorCMM]

It lets me run the query, but then that text box displays "#Error"

The original table had a space too. I tried the brackets, but it still
didn't work.

Might have been helpful to know what the error was...

Did the original table have a space in its name too? The only suggestion I
have is to reference "[Details Query]" (with brackets) since the object name
has a space in it.

HTH,

I have a database that is used to log employee compliants. A query
(Details
Qry) is used to summarize all of the compliants within a specified date
range
that is entered by the user. I am trying to put together a report that
includes a field that identifies the oldest report still under
investigation.
I tried using the following DMin function, but I keep getting an error:

=DMin("[Date of Incident]","Details Qry"," [Action Taken]='Investigation
in
Process'")

If I use the same function based on the original table, it works, but not
on
the query. Does the above function not work when you are entering your
own
date range? Any help would be appreciated. Thanks!