giving count for each year in table and displaying on a form.

[_Bigred]

I am trying to have a form that will give me

a total count of "grievance records" by year

E.G
1986 - 4
1987 - 26
1988 - 45
etc... (right now my years go from 1986 through 2003).

I have tried the following in a Unbound text box but get the dreaded "error"
in the text box. (this should display a total count for grievances filed in
1986. how do i make it work?

=DCount("[Date Submitted]","[Grievance Table]","[Date Submitted]" =

#12/31/1985# AND <#1/1/1987#")

Thanks in advance,
_Bigred

 

[chas]

Hi,

try:

dcount("[Date Submitted]","[Grievance Table]","[Date
Submitted] between #01/01/1986# and #12/31/1986#")

this should return a count of the records for 1986

hth

chas

-----Original Message-----
I am trying to have a form that will give me

a total count of "grievance records" by year

E.G
1986 - 4
1987 - 26
1988 - 45
etc... (right now my years go from 1986 through 2003).

I have tried the following in a Unbound text box but get the dreaded "error"
in the text box. (this should display a total count for grievances filed in
1986. how do i make it work?

=DCount("[Date Submitted]","[Grievance Table]","[Date Submitted]" =

#12/31/1985# AND <#1/1/1987#")

Thanks in advance,
_Bigred


.

 

[_Bigred]

dcount("[Date Submitted]","[Grievance Table]","[Date
Submitted] between #01/01/1986# and #12/31/1986#")


tried that but I'm still get "error" in the unbound text box?

any other ideas of how to get it working?


Thanks,
_Bigred

Hi,

try:

dcount("[Date Submitted]","[Grievance Table]","[Date
Submitted] between #01/01/1986# and #12/31/1986#")

this should return a count of the records for 1986

hth

chas

-----Original Message-----
I am trying to have a form that will give me

a total count of "grievance records" by year

E.G
1986 - 4
1987 - 26
1988 - 45
etc... (right now my years go from 1986 through 2003).

I have tried the following in a Unbound text box but get the dreaded "error"
in the text box. (this should display a total count for grievances filed in
1986. how do i make it work?

=DCount("[Date Submitted]","[Grievance Table]","[Date Submitted]" =

#12/31/1985# AND <#1/1/1987#")

Thanks in advance,
_Bigred


.

 

[_Bigred]

yes I have the = at the beginning, but I still get the "error" in the
unbound text box?

_Bigred

HI,

did you include the = at the beginning (which I left out)

chas

-----Original Message-----
dcount("[Date Submitted]","[Grievance Table]","[Date
Submitted] between #01/01/1986# and #12/31/1986#")


tried that but I'm still get "error" in the unbound text box?

any other ideas of how to get it working?


Thanks,
_Bigred

Hi,

try:

dcount("[Date Submitted]","[Grievance Table]","[Date
Submitted] between #01/01/1986# and #12/31/1986#")

this should return a count of the records for 1986

hth

chas

-----Original Message-----
I am trying to have a form that will give me

a total count of "grievance records" by year

E.G
1986 - 4
1987 - 26
1988 - 45
etc... (right now my years go from 1986 through 2003).

I have tried the following in a Unbound text box but get
the dreaded "error"
in the text box. (this should display a total count for
grievances filed in
1986. how do i make it work?

=DCount("[Date Submitted]","[Grievance Table]","[Date
Submitted]" =
#12/31/1985# AND <#1/1/1987#")

Thanks in advance,
_Bigred


.

.