I am trying to create a new table and not use the update query to update blank values in Location and manager as "N/A"
But I keep getting the following error "You tried to execute a query that does not include the speicfied expression 'Nz([Table1]![Location],"n/a")' as part of an aggregate function.
Code:SELECT Table1.Item, Nz([Table1]![Location],"n/a") AS Location, Table1.Manager INTO AlldatafilledFROM Table1 GROUP BY Table1.Item;