If PartNumber is numeric, you don't need the extra single quotes, if it is text,you do need them.
I would be very very very suspicious of how Access would handle those square brackets in Q[-]shortages. Change the name of your query simply to QShortages. Square brackets are normally used to indicate that 2 words are to be treated as one, so you can't use Last Name, but you can use [Last Name]
Sorry to go on, but "name" is a reserved word, and should not be used as the name of a field in any table. Don't know what you are after but FacilityName is perfectly acceptable.
Another reserved word that frequently causes trouble is "Date"
-
DLookUp("FacilityName","QShortages","ItemNumber=" & [PartNumber]) AS Facility
-