hi
can any body figure out, its not working
=DCount("*","Students","Students.Sclass=1 and Students.Ssection=A")
=DCount("*","Students","Students.Sclass=" & 1 and "Students.Ssection=" & "A")
Thanks
hi
can any body figure out, its not working
=DCount("*","Students","Students.Sclass=1 and Students.Ssection=A")
=DCount("*","Students","Students.Sclass=" & 1 and "Students.Ssection=" & "A")
Thanks
string values must be surrounded by quotes (while inside quotes):
=DCount("*","Students","Sclass=1 and Ssection='A' ")
thanks
ranman256