Nuill or IsNull

[Jerseynjphillypa]

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.

SELECT Table1.Item, Nz([Table1]![Location],"n/a") AS Location, Table1.Manager INTO AlldatafilledFROM Table1
GROUP BY Table1.Item;

[jzwp11]

Get rid of the GROUP BY clause