Update Query with parameter query

[mimikate]

I am so confused on how to do this. I have a college project to do and we had a fake scenario of a business and we had to set up the whole database.



Basically there is a question that asks me to make a parameter and update query together....with a variable. I am so confused. If anyone is good with this please please please get back to me and I can explain the actual problem further.

This is driving me crazy

[jgelpi16]

I think I need some specifics before I try to answer this. Can you provide more specifics/sample data and I will try to help out.

[objNoob]

I am so confused on how to do this. I have a college project to do and we had a fake scenario of a business and we had to set up the whole database.

Basically there is a question that asks me to make a parameter and update query together....with a variable. I am so confused. If anyone is good with this please please please get back to me and I can explain the actual problem further.

This is driving me crazy

Basically, you are being asked to make an update query that accepts a parameter in variable format.

In access, if you create an update query as such...

UPDATE tblMyCompanyTable SET EmployeeWage=varWageParam WHERE EmployeeID=varEmpParam;

Access when executing that code will have been unable to determine varWageParam and varEmpParam's values, thus prompting you, the user, for those values. This is an update query that uses variables which are assigned by the user. An update query that accepts parameters.... Voila~

Warning: Not all DBMS act this way.