add records in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a simple query, and added some calculated fields. It does not
allow new records to be added. Is this due to the addition of the calculated
fields or is there a property that needs to be changed?

Thanks!
 
IT depends on the calculated fields. Did you use any of the aggregate functions
to do the calculations (Sum, Avg, Count)?

Normally adding a calculated field won't make the query not updateable, only the
calculated field itself. Is the the query updateable if you drop the calculated field(s)?
 
Back
Top