select query with conditions

[spec]

Hi friends,

I had two tables parent(f1) , child(f1,f2,f3).
I had to display f3 value for parent(f1) when f1 has only one f2,
if f2 values are more than one for single f1 and if all f3 values are 0 then
i should display f3 as 0, else if some values for f3 are nonZeros and some are Zeros then
is should display f3 value as '-'.

How to do this?
please any suggestions?

Thanks.

 

[Hellsangel]

Pls Solve my problem!!Anyone Pls!!

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!!