• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Missing Required Fields

Q1:I created a query that shows the tentative append record, but when I try to add a new record, I receive a “The field 'FieldName'can't contain a Null value because the Required property is set to True” error message. I don't want FieldName in the query.
A1: You must include in your query result set all columns whose Required property value is set to Yes. This means, of course, that each of these fields must have a value typed in it. A unique primary key value is required to add a new record to any table with a primary key. For example, attempting to add a new record to a query on the Customers table that doesn't include CustomerID and CustomerName columns fails, because CustomerID is the primary key and CustomerName is a required field of the table.

Nonupdatable Summary Queries

Q1:I can't update data in my summary query.
A1: Summary queries aggregate data, so there's no direct relationship between the content of a query row and records in the underlying table(s). This means that there's no way for changes to aggregate values (dates, totals, averages, and the like) to propagate back to the table records. If you want to fudge the figures, change your select summary query to a make-table summary query, and then alter the data in the new table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint