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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
