25th July 08:51
Infopath submit query to SQL advanced - need help
I need to submit my @Total_Amount and @Project_Cost_Centre fields into my SQL
query in the place of the Â£1000 and the 1510000 below. I then need to grab
the result of the query and submit the form to the email address signified by
Surname, First Name output from the query.
SELECT DISTINCT e.vchrFirst_Name, e.vchrSurname, ecc.vchrCost_Centre,
FROM tblEmployees e INNER JOIN
tblEmployee_Cost_Centre ecc ON e.vchrCost_Centre =
ecc.vchrCost_Centre INNER JOIN
tblAuthority_Codes ac ON e.vchrAuthority_Code =
WHERE (ac.vchrPersonal_Expenses = 'Â£1,000' OR
ac.vchrPersonal_Expenses = 'Â£1000') AND
(e.vchrCost_Centre = '1510000')
I want to replace the numbers with my fields but that doesn't seem the way.
Can anyone who is particularly clever help me as this is way out of my depth.