var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Trying to use Dcount in a report
I am in need of some help. I know just enough about Access to shoot myself in the foot and right now I just can't figure this out.
I want to create an unbound text box with the Dcount function that will count the number of records in my table under a specific column that have values greater than 0.
I hope I explained that well enough. This is what I started with and it returns an #Error on the report.
=DCount("[GB SB Fax Proof Green]","data","[GB SB Fax Proof Green] = '0'")
The table is named "Data".
The field I want to count is called "GB SB Fax Proof Green".
All values are numerical.
Am I just missing something? Thanks for any help.
Nevermind, I think I finally got what I wanted. Think it was som syntax problems.
=DCount("[GB SB Fax Proof Green]","data","[GB SB Fax Proof Green] >= 1")