Hi there,
I have a database that handles all the administration of training courses offered in our establishment.
I have a query that is supposed to find all the courses that are offered by a particular school this year but exclude all the Microsoft courses. Here's the query but it returns all the courses offered by the school including all Microsoft courses:
SELECT Daten.FoBiID, Daten.Jahr, Daten.Anbieter, Daten.Fortbildung, Daten.Von1, Daten.Bis1, Daten.Kennziffer, Daten.Aktenzeichen, Daten.Abgeschlossen, Daten.FoBi_Key
FROM Daten
WHERE (((Daten.Jahr)=Year(Date())) AND ((Daten.Anbieter)="Zentrale IT Betrieb") AND ((Daten.Fortbildung) Not Like "Microsoft*'"))
ORDER BY Daten.Fortbildung, Daten.Von1;
What am I missing?
Regards,
Martin
I have a database that handles all the administration of training courses offered in our establishment.
I have a query that is supposed to find all the courses that are offered by a particular school this year but exclude all the Microsoft courses. Here's the query but it returns all the courses offered by the school including all Microsoft courses:
SELECT Daten.FoBiID, Daten.Jahr, Daten.Anbieter, Daten.Fortbildung, Daten.Von1, Daten.Bis1, Daten.Kennziffer, Daten.Aktenzeichen, Daten.Abgeschlossen, Daten.FoBi_Key
FROM Daten
WHERE (((Daten.Jahr)=Year(Date())) AND ((Daten.Anbieter)="Zentrale IT Betrieb") AND ((Daten.Fortbildung) Not Like "Microsoft*'"))
ORDER BY Daten.Fortbildung, Daten.Von1;
What am I missing?
Regards,
Martin