I'm getting this message when trying to do an update query:

You tried to execute a query that doesn’t include the specified expression ‘tblRental]![PickupDate’ as part of an aggregate function.

Can someone suggest what my problem might be??

Thanks

Either your table name or field name is misspelled.