DMin Function

A

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!
 
G

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,
 
A

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.

George Nicholson said:
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 said:
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top