Advanced Question - On submission query SQL database with form val

A

Adam Harding

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,
ac.vchrPersonal_Expenses

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 =
ac.vchrAuthority_Code

WHERE (ac.vchrPersonal_Expenses = '£1,000' OR

ac.vchrPersonal_Expenses = '£1000') AND
(e.vchrCost_Centre = '1510000')

Can anyone who is particularly clever help me as this is way out of my depth.

Cheers Adam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL JOIN for Unmatched records & JOIN fields from another table 4
Query SQL Database using InfoPath form field 6
How do you ignore entire tables in an Inner Join Query? 16
query very slow on SQL; maybe replace with search box? 7
Using a Query to Populate Form Control 1
Runtime 3061: Too Few Parameters on nested query 1
Select, Insert, Update, and Delete – SQL Question 1
Form that Runs a Query. 8

Top