EduardM
asked on
My first query in Access 2007
Hello!
Help beginner to integrate two queries in one in Access 2007, please:
1. SELECT [Type1]*2+[Type2]*3+[Type3 ]*5 AS Mark, *
FROM Table1;
2. SELECT Query1.Mark, *
FROM Query1
WHERE (((Query1.Mark)=DMax("[Que ry1]![Mark ]","Query1 ")));
Thanks!
Table1.jpg
Help beginner to integrate two queries in one in Access 2007, please:
1. SELECT [Type1]*2+[Type2]*3+[Type3
FROM Table1;
2. SELECT Query1.Mark, *
FROM Query1
WHERE (((Query1.Mark)=DMax("[Que
Thanks!
Table1.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome!
I'm not strong in books on Access - actually, have never bought any - but browse Amazon and study the ratings of the offerings.
/gustav
I'm not strong in books on Access - actually, have never bought any - but browse Amazon and study the ratings of the offerings.
/gustav
ASKER
Can you advise the good book on Access?