On the DRW here is the custom query SQL I am using.

UPDATE DISTINCTROW
Results
SET status='::status::', techrepid='::techrepid::'
WHERE ID=::ID::

This is the error I get:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

It works fine with updating only one field but I would like to update two or more fields. What do you think?

techrepid=::techrepid::

------------------
Brian---