Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers

You want to count how many records for a given customer based on CustomerID which is of field type short text in table tblCustomer. The customer id we want the count for is 123-AC. We are using the domain aggregate function DCount and assign it to an integer variable intC what is the correct syntax.

intC = DCount("*","tblCustomer","[CustomerID] = " & 123-AC)
intC = DCount("tblCustomer","*","Me.CustomerID = 123-AC")
intC = DCount ("*","tblCustomer","[CustomerID] = ' & 123-AC & "'")
Syntax is incorrect can't save in an integer variable if you are counting on a field type of short text.
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon