Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009
    Posts
    24

    Unanswered: dcount syntax correct?

    Is this dcount syntax correct? My report textbox returns an #Error instead of a number count.

    Code:
    =DCount("[Order Number]","qrytestTotal_Orders","[DaystoShip]=2 OR [DaystoShip]=3 AND [SEC ID]Like '3*' AND [Order Priority]>3")
    Thanks!

  2. #2
    Join Date
    Oct 2009
    Posts
    24
    Nevermind I figured it out.

Posting Permissions

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