what determines if you can add a record to a query?

  • Thread starter Thread starter MattE
  • Start date Start date
M

MattE

I have two queries, each based on a simple single table (a different
table for each query). One allows me to add a record and the other
does not (either programmatically or via the Access UI).

Can anybody point me to how I can tell why? Thanks!
 
MattE said:
I have two queries, each based on a simple single table (a different
table for each query). One allows me to add a record and the other
does not (either programmatically or via the Access UI).

Can anybody point me to how I can tell why? Thanks!
Click to expand...

There is a help topic named "When can I update data in a query?"
 
Ah, I thought I'd seen that before, thanks! Turns out "Group By" had
snuck in there, removing that fixed it.
Matt
 
Back
Top