Dcount

[Gaetanm via AccessMonster.com]

I have a REPORT which is being populated via a query.
The field I'm trying to count is [INS EFFECTIVE]
this is a date field.

I can use =count in the Report footer it will give me
a total of ALL the [INS EFFECTIVE].

I'm trying to get a count of [INS EFFECTIVE] = 1/11/1111.

I tried =DCount("1/11/1111","[ins effective]") but all this gives me is error.


Any suggestions

 

[Al Campagna]

Gaetanm,
Try...
Sum(IIF([Ins Effective] = #1/11/1111#, 1, 0)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Gaetanm via AccessMonster.com]

AL

Thanks for the quick reply. The following I put in my report footer:

sum(IIF([ins effective] = #1/11/1111#,1,0)

I received the following error:

Syntax error in query expression
'First([sum(IFF([ins effective] = #1/11/1111#,1,0)])'


Any Ideas

Thanks

Gaetanm

Gaetanm,
Try...
Sum(IIF([Ins Effective] = #1/11/1111#, 1, 0)

I have a REPORT which is being populated via a query.
The field I'm trying to count is [INS EFFECTIVE]

[quoted text clipped - 9 lines]

Any suggestions

 

[Gaetanm via AccessMonster.com]

AL

Thanks for the quick reply. The following I put in my report footer:

sum(IIF([ins effective] = #1/11/1111#,1,0)

I received the following error:

Syntax error in query expression
'First([sum(IFF([ins effective] = #1/11/1111#,1,0)])'


Any Ideas

Thanks

Gaetanm

Gaetanm,
Try...
Sum(IIF([Ins Effective] = #1/11/1111#, 1, 0)

I have a REPORT which is being populated via a query.
The field I'm trying to count is [INS EFFECTIVE]

[quoted text clipped - 9 lines]

Any suggestions

 

[Gaetanm via AccessMonster.com]

AL

Thanks for the quick reply. The following I put in my report footer:

sum(IIF([ins effective] = #1/11/1111#,1,0)

I received the following error:

Syntax error in query expression
'First([sum(IFF([ins effective] = #1/11/1111#,1,0)])'


Any Ideas

Thanks

Gaetanm

Gaetanm,
Try...
Sum(IIF([Ins Effective] = #1/11/1111#, 1, 0)

I have a REPORT which is being populated via a query.
The field I'm trying to count is [INS EFFECTIVE]

[quoted text clipped - 9 lines]

Any suggestions

 

[Douglas J. Steele]

There's a missing closing quote. Try

sum(IIF([ins effective] = #1/11/1111#,1,0))


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

AL

Thanks for the quick reply. The following I put in my report footer:

sum(IIF([ins effective] = #1/11/1111#,1,0)

I received the following error:

Syntax error in query expression
'First([sum(IFF([ins effective] = #1/11/1111#,1,0)])'


Any Ideas

Thanks

Gaetanm

Gaetanm,
Try...
Sum(IIF([Ins Effective] = #1/11/1111#, 1, 0)

I have a REPORT which is being populated via a query.
The field I'm trying to count is [INS EFFECTIVE]

[quoted text clipped - 9 lines]

Any suggestions

 

[Douglas J. Steele]

Sorry, that should have been "There's a missing closing parenthesis."

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

There's a missing closing quote. Try

sum(IIF([ins effective] = #1/11/1111#,1,0))


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

AL

Thanks for the quick reply. The following I put in my report footer:

sum(IIF([ins effective] = #1/11/1111#,1,0)

I received the following error:

Syntax error in query expression
'First([sum(IFF([ins effective] = #1/11/1111#,1,0)])'


Any Ideas

Thanks

Gaetanm

Gaetanm,
Try...
Sum(IIF([Ins Effective] = #1/11/1111#, 1, 0)
I have a REPORT which is being populated via a query.
The field I'm trying to count is [INS EFFECTIVE]
[quoted text clipped - 9 lines]

Any suggestions

 

[Gaetanm via AccessMonster.com]

Al

Iput in:

sum(IIF([ins effective] = #1/11/1111#,1,0))

I received the following:

Extra ( in query expression
'First([sum(IFF([ins effective] = #1/11/1111#,1,0))])'

AL

Thanks for the quick reply. The following I put in my report footer:

sum(IIF([ins effective] = #1/11/1111#,1,0)

I received the following error:

Syntax error in query expression
'First([sum(IFF([ins effective] = #1/11/1111#,1,0)])'

Any Ideas

Thanks

Gaetanm

Gaetanm,
Try...

[quoted text clipped - 4 lines]

 

[Gaetanm via AccessMonster.com]

Al

I did as you suggested. I even cut and paste from this post and still got:
Extra ( in query expression
'First([sum(IFF([ins effective] = #1/11/1111#,1,0))])'

Any Ideas

Gaetanm

Al

Iput in:

sum(IIF([ins effective] = #1/11/1111#,1,0))

I received the following:

Extra ( in query expression
'First([sum(IFF([ins effective] = #1/11/1111#,1,0))])'

Gaetan

AL

[quoted text clipped - 17 lines]