Recent content by arstein

Thanks. But I still get the same error.

OK. I'm not really sure why this is too complicated -- Access doesn't seem to have trouble parsing it, it just seems to object to the nature of the query, leading me to wonder if there is an approved way to do the same thing. But if your method works better, I'm game. I'm also an Access...

Apologies if this is a basic question. Here's my situation: I'm trying to update rows in a table based on a count of items in the same table. The table in question contains order line items. On each line item, I'd like to store the total number of items attached to that order (because it...