I want to run a make table query that groups on a field called code and then creates a new field which is a Yes/No field as a tick box.
Is this poss??
Here is the code I have so far (very simple I know)
SELECT tblStoreDevOrders.Code, No AS Selected INTO tblCapexCodes
GROUP BY tblStoreDevOrders.Code, No;