Hello Friends......."HAPPY NEW YEAR ALL OF YOU"
I am in learning stage and I am trying to set a task, but can't. I have a form named "PAY", which has a text box named "WageRate" and combobox named "EmpName"
and having tables are as below
TblEmployees
ID EmpName Wage 1 Venu Rs:150.00 2 Ravi Rs:200.00 3 Kiran Rs:180.00 4 Balu Rs:195.00
TblIncrement
ID EmpName Increment 1 Venu Rs:50.00 2 Ravi Rs:30.00 3 Kiran Rs:70.00 4 Balu Rs:35.00
qryWageIncrement
ID EmpName Wage Increment DateFrom 1 Venu Rs:150.00 Rs:50.00 12-Jan-2013 2 Ravi Rs:200.00 Rs:30.00 01-Dec-2012 3 Kiran Rs:180.00 Rs:70.00 04-Jan-2013 4 Balu Rs:195.00 Rs:35.00 15-May-2012
Rowsource: (of combobox is)
SELECT WageIncrement.EmpName, WageIncrement.Wage, WageIncrement.Increment, WageIncrement.DateFrom FROM WageIncrement;
I am trying to set to display in textbox named "WageRate" is [Wage]+[Increment] after scheduled/DateFrom date and don't want to display in before date when I select the combobox.
please help me all that how to write a code for the above.
Thanking you all