Someone Pls HELP!!

[Hellsangel]

Hi,

I do not know how to post a message anyother way.... so please excuse me for havin post this, this way!!

I have a table.... called
ApraisalEntrySrCSR...... contents(in columns) ID,FirstName,LastName,DateOfJoining, Perfomance, Attitude, LeadershopSkills, Attendance

Now I created a query....called
ApraisalCalculationSrCSR...... contents
all of the above feilds, plus.....[Expr1]which =([Perfomance]/5)*100
[Expr2]which =([Attitude]/5)*100
[Expr3]which =([LeadershipSkills]/5)*100
[Expr4]which =([Attendance]/5)*100
[Expr5]which =([Expr1]+ [Expr2]+[Expr3]+ [Expr4])/4

Now in this query [Expr5] is the average score
I have another Table called........ApraisalSrCSR
which Contais...(in columns) Percentage,Amount

In the query ApraisalCaculationSrCSR....[Expr5] is the percentage
Now how do I get the amount for that persentage form the ApraisalSrCSR table?
Whats the expresion that I need to give in the ApraisalCalculationSrCSR query to get this amount? (I tried the DLOOKUP function, but never seem to get it right!!)

Could someone pls HELP me!!

 

[Brianwarnock]

Could you have another query taking in ApraisalCalculationSrCSR and ApraisalSrCSR, join [EXPR5] and percentage
.

Brian

 

[RuralGuy]

Why not just join the two queries on ID?

 

[Brianwarnock]

Why not just join the two queries on ID?

Brian