Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    3

    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.

  2. #2
    Join Date
    Dec 2004
    Posts
    3
    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")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •