Hi, I have 3 parameters on my form. StartDate (datetime), EndDate (datetime) and CompanyName(string). The default values are: StartDate (Non-queried) 1-1-2005, EndDate (Non-queried) 1-1-2008, CompanyName (From query) DataSetBelow, Value field (AccountFamily):
SELECT DISTINCT AccountFamily
FROM CallDataRecords
The table on the form contains the following DataSet:
SELECT Salutation, InboundTimeMS, OutboundTimeMS, ModifiedOn, IsRightParty, AccountFamily
FROM CallDataRecords
WHERE AccountFamily = @CompanyName
AND ModifiedOn
BETWEEN @StartDate AND @EndDate
The error I get is: "Query execution failed for data set (one directly above)".
"Must declare the scalar variable "@CompanyName".
Can anybody shed light please
Thanks, Dan