Search results

thanks for the assistance :) No, qryUnionResourcesColumnsToRows is union type query that converts a flat-file import table into a more normalised looking dataset. The dataset has three fields ShiftID, Commodity and Allocation. The SQL for the union is: SELECT ShiftID, "Commodity1" AS...

It's asking for the values from both field names of the union query, qryUnionResourcesColumnsToRows, specified in the WHERE clause. These fields were added as Criteria using the Expression builder so I think they're spelt correctly.

Hello, I am trying to build an UPDATE query in Access 2003 via the Design view but keep getting an 'Enter Parameter Value' dialogue every time I attempt to preview the results in datasheet view. The update query is referencing the results of a saved union query that normalises data imported...