Hello to everyone,
In my own database, I linked customers table with orders table using
one-to-many relation. I need to check status of last order for each
customer and then set customer's status. I made a query using LAST and
GROUP BY to select last order for each customer and I wanted to use it
in UPDATE query, but it seems to be impossible. Is here anybody who
knows how to solve this problem? (I work with MS Access).
Adam