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;