Search results

SELECT Table1.ID, Table1.Dof, ([Forms]![Form1]![Text0]-[Dof])/365.25 AS Expr1 FROM Table1 WHERE (((([Forms]![Form1]![Text0]-[Dof])/365.25)>[Forms]![Form1]![Text2])); dosent returns years greater than the number entered in form1

iam entering date , and number of year from form i want query to calculate who have more than number of years entered in textbox in the form the query i made doesnt return it correctly if any can help please

iam entering date , and number of year from form i want query to calculate who have more than number of years entered in textbox in the form the query i made doesnt return it correctly if any can help please

;) yaa thanks for help

the answer must be sam and tony anyone can help please thanks

look at query1 please ; i want it to show me only sam ,the only one who doesnt has med3

did u saw the database file????

take a look please

can i send the database file????

thank u for help if i want to find who has medal1 and dont have medal3

no lets say " john has medal1 and medal3 , tony has medal4 and medal3 , sam has medal1 and medal4 ............ i wana find who dosent has medal3 answer is" only sam" not jhon medal1 tony medal4 sam medal1,medal4 !!!!!!!:confused:

<> 1 or <>2 like "not like " i want to find persons who dosent has ( medal1 or medal 2 but may be he has medal3) example ; jhon has medal1 and medal2 but he dosent has medal3

hi all , i have 2 tabels first one personal info have pnum,name,rank,dateofbirth..... second have pnum related to pnum in personal info and medals_type ..... there is 12 medals type lets say medal1 2 3 4 5 ....... i want to find who dosent have medal 5 or 3 or 2 in parameter [ ] and thanks for...

hi all , i have 2 tabels first one personal info have pnum,name,rank,dateofbirth..... second have pnum related to pnum in personal info and medals_type ..... there is 12 medals type lets say medal1 2 3 4 5 ....... i want to find who dosent have medal 5 or 3 or 2 in parameter [ ] and thanks for...