DCount Rookie Question

[knowshowrosegrows]

I am self-taught on this software and just beginning to understand syntax.

I am trying to do what seems to be a simple DCOUNT and I don't have it
right. I want to count the times in a specific date range that the records
in the Denial Specific Info Table has the First Level Appeal Determination
Field register "Denied."

My most recent attempt didnt even include the date range question and it is
not working
Expr1: DCount("[RecordID]","[Denial Specific Info]","[First Level Appeal

Determinations]='Denied'").

Now, my Denial Specific Info table has three test records. One = "Denied"
and Two = "Granted." When I run the query with the syntax I have I get
a table with one field titled Expr1. In that field there are three rows with
a "1" in each row. So it did count the number of "Denied" I have but it
repeated it for the same number of records in the original table.

 

[Rick Brandt]

I am self-taught on this software and just beginning to understand
syntax.

I am trying to do what seems to be a simple DCOUNT and I don't have it
right. I want to count the times in a specific date range that the
records in the Denial Specific Info Table has the First Level Appeal
Determination Field register "Denied."

My most recent attempt didnt even include the date range question and
it is not working
Expr1: DCount("[RecordID]","[Denial Specific Info]","[First Level
Appeal

Determinations]='Denied'").

Now, my Denial Specific Info table has three test records. One =
"Denied" and Two = "Granted." When I run the query with the syntax I
have I get
a table with one field titled Expr1. In that field there are three
rows with a "1" in each row. So it did count the number of "Denied"
I have but it repeated it for the same number of records in the
original table.

Normally one would not use DCount() in a query except in very special
circumstances. It would typically be used in a form or report or in code to
return a count from "some other query or table".

In a query you just show the Totals row in the query designer by using
"Show - Totals" from the menu and then use Count in the grid as the Totals
option. The SQL of such a query would be...

SELECT Count(*)
FROM [Denial Specific Info]
WHERE [First Level Appeal] = "Denied"
AND DateFieldName >= #2007-01-01#
AND DateFieldName < #2007-03-28#

 

[knowshowrosegrows]

Aha! Another light comes on. That SQL worked perfectly.
--
Thanks

I am self-taught on this software and just beginning to understand
syntax.

I am trying to do what seems to be a simple DCOUNT and I don't have it
right. I want to count the times in a specific date range that the
records in the Denial Specific Info Table has the First Level Appeal
Determination Field register "Denied."

My most recent attempt didnt even include the date range question and
it is not working
Expr1: DCount("[RecordID]","[Denial Specific Info]","[First Level
Appeal

Determinations]='Denied'").

Now, my Denial Specific Info table has three test records. One =
"Denied" and Two = "Granted." When I run the query with the syntax I
have I get
a table with one field titled Expr1. In that field there are three
rows with a "1" in each row. So it did count the number of "Denied"
I have but it repeated it for the same number of records in the
original table.

Normally one would not use DCount() in a query except in very special
circumstances. It would typically be used in a form or report or in code to
return a count from "some other query or table".

In a query you just show the Totals row in the query designer by using
"Show - Totals" from the menu and then use Count in the grid as the Totals
option. The SQL of such a query would be...

SELECT Count(*)
FROM [Denial Specific Info]
WHERE [First Level Appeal] = "Denied"
AND DateFieldName >= #2007-01-01#
AND DateFieldName < #2007-03-28#