Inserting value from SQL query into single field

[Tony D.]

am trying to insert the result of an SQL query into a field in FMP 9.

Here is my SQL statement (which produces the correct result)

SELECT count(*) FROM smart_cd.USAGE_SAS WHERE FTR_SERVICE_TYPE = 'C'

I can run the SQL query in a script using "Execute SQL", but I can't figure out how to send the results to a field in FMP.

I don't want to hard code the value of the field to equal the SQL statement (as in a calculation), as I want to be able to retrieve this information at will.

Any assistance is appreciated.

Thanks,

Tony