Good afternoon
I have a union query which is getting some of its data from a combo box result.
Within the union query it is stating the First column rather than the second column.
The data in the table does state the second column as I want it to do, but I can not get the union query to follow suit.
Union Query is
SELECT [ProductionID], [Stock1], [Stock2], [Stock3], [Stock4], [Operative], [1DeliveryID], [1DeliveryProduct], [1Temp] FROM TMeatP
WHERE [1DeliveryID] Is Not Null
UNION ALL
SELECT [ProductionID], [Stock1], [Stock2], [Stock3], [Stock4], [Operative], [2DeliveryID], [2DeliveryProduct], [2Temp] FROM TMeatP
WHERE [2DeliveryID] Is Not Null
The 4 x Stock columns and Operative are combo boxes and all showing the ID number in the union query.
Regards Ian
I have a union query which is getting some of its data from a combo box result.
Within the union query it is stating the First column rather than the second column.
The data in the table does state the second column as I want it to do, but I can not get the union query to follow suit.
Union Query is
SELECT [ProductionID], [Stock1], [Stock2], [Stock3], [Stock4], [Operative], [1DeliveryID], [1DeliveryProduct], [1Temp] FROM TMeatP
WHERE [1DeliveryID] Is Not Null
UNION ALL
SELECT [ProductionID], [Stock1], [Stock2], [Stock3], [Stock4], [Operative], [2DeliveryID], [2DeliveryProduct], [2Temp] FROM TMeatP
WHERE [2DeliveryID] Is Not Null
The 4 x Stock columns and Operative are combo boxes and all showing the ID number in the union query.
Regards Ian