Is this dcount syntax correct? My report textbox returns an #Error instead of a #.
Code:=DCount("[Order Number]","qrytestTotal_Orders","[DaystoShip]=2 OR [DaystoShip]=3 AND [SEC ID]Like '3*' AND [Order Priority]>3")
Is this dcount syntax correct? My report textbox returns an #Error instead of a #.
Code:=DCount("[Order Number]","qrytestTotal_Orders","[DaystoShip]=2 OR [DaystoShip]=3 AND [SEC ID]Like '3*' AND [Order Priority]>3")
Nevermind - I figured it out.
Care to share your solution with others that read this thread?