What’s wrong with the following count statement:
=Count(<TICKET_NUMBER> ForEach(<TICKET_NUMBER>) Where(<Query>="FMS Dispatched to Force" And <ENTRY_TYPE>="Trouble Report" And <CREATETODISPATCH><=<SLA>))
Ticket Number is the primary Key for the table and is a Text Data Type
Query is a Text Data column
Entry Type is a Text Data Column
CreateToDispatch is a number (i.e. 1234)
SLA is a number (i.e. 1234)
When I attempt to build this I get a Syntax Error (DMB0007) and BO selects " ".
Can anyone help?
thedryden (BOB member since 2007-11-07)