problem with query

S

sofiane

I have a new problem (another one!) and I hope I can explain you clearly:



I have two queries:

* Query_Who_has
SELECT [courses attended].[sap number],[courses list].[courses list],
[courses list].[reference provider]
FROM [courses list] RIGHT JOIN [courses attended].[courses attended]
WHERE ((([courses list].[courses list] like [forms]![main
menu]!txt_course_not & “ * â€

* Query_Who_Has_not_done_course
SELECT users.[sap number], users.[last name],users.[first name],users.type,
users.status, query_who_has.[course list]
FROM users LEFT JOIN query_who_has ON users.[sap
number]=query_who_has.[sap number]
WHERE (((Query_who_has.[courses list]) ISnull));

I have put a text box on a form ( “txt_course_notâ€) , and when I type a
letter or the first word of a course name I can have a list of all the person
who have not done this course ( you help to have that )

But my problem is if I have e.g. 5 course starting by the letter A , and If
I type this letterin the txt box the query displays only the results for the
first course and not for all … what I have to write in my query
(“query_who_has_not_done_courseâ€) to display all the results for all courses
??

I hope i was enough clear ;p

Thank you for your help
 
Top