How to simplify this query?

I am somewhat new to Access and I need help with a query that Access does not execute because of Not enough space on temporary disk. I have one table. A product may have up to 3 IDs and a place to sell. If there is a place to sell, the name will be shown along with a combined identifier consisting of the three IDs plus the *"k1"* prefix. An example of the resulting combined identifier would be *"k1 3232 232 1231233"* (if it has three IDs). The column names are *ProductID1*, *ProductID2*, *ProductID3*, *Place1*. This is the query: SELECT DISTINCT IIf(IsNull([Tam_Liste]![Place1]),"","k1 " & [Tam_Liste]![ProductID1] & " " & [Tam_Liste]![ProductID2] & " " & [Tam_Liste]![ProductID3]) AS item_sku, Tam_Liste.[Place1] FROM Tam_Liste;