Dcount

[smcgrath via AccessMonster.com]

I have a report that uses a form to filter the persontype which works fine,
However, I would like to count the number of people that made a donation and
the total number of that particular person type so that I can eventually get
a percentage of persontype that made a donation (#of persons that made
donation/#persontype) I can't get the Dcount function to only count the
person type that is filtered from the form.

I have tried Dcount("[Perstype]","members","'[PersType]=&[Forms]![Form1]!
[perstype]'")

What am I missing?

 

[Duane Hookom]

If PersType is numeric:
Dcount("[Perstype]","members","[PersType]=" & [Forms]![Form1]! [perstype])


If PersType is text:
Dcount("[Perstype]","members","[PersType]=""" & [Forms]![Form1]! [perstype]
& """")

 

[smcgrath via AccessMonster.com]

Thank you very very much...it worked perfectly.

If PersType is numeric:
Dcount("[Perstype]","members","[PersType]=" & [Forms]![Form1]! [perstype])

If PersType is text:
Dcount("[Perstype]","members","[PersType]=""" & [Forms]![Form1]! [perstype]
& """")

I have a report that uses a form to filter the persontype which works fine,
However, I would like to count the number of people that made a donation

[quoted text clipped - 9 lines]

What am I missing?