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

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_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#")
Click to expand...

Thanks in advance,
_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#")
Click to expand...

Thanks in advance,
_Bigred


.
Click to expand...
 
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

chas said:
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#")
Click to expand...

Thanks in advance,
_Bigred


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

_Bigred



chas said:
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

chas said:
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


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top