Caporegime
I'm updating an old query to make it more useful, but have hit a stumbling block.
There is a single table holding bucketloads of data (Sales Service History)
I have a normal query that brings back all the BookingIDs when the booking was confirmed and on what date.
There is then an update query that previously was used to update a blank field (Ext Tool New Business Transaction) in the original Sales Service History table with the text "Confirmed".
This meant that any instance of that BookingID would have "Confirmed" in that field.
I'm trying to make this more useful by not excluding any activity that takes place after the date the booking was confirmed, as anything before confirmation is considered Sales activity, and any post is Service activity.
I have my new query as such:
What I need it to do is update the Ext Tool New Business Transaction field to be whatever the Activity Date is in the Qry Bookings to BK results.
I can't figure out how to do this, it only allows me to enter a blanket text to be updated on all BookingIDs, rather than a dynamic update based on the Activity Date in the Qry results.
Any ideas?
Thanks
There is a single table holding bucketloads of data (Sales Service History)
I have a normal query that brings back all the BookingIDs when the booking was confirmed and on what date.
There is then an update query that previously was used to update a blank field (Ext Tool New Business Transaction) in the original Sales Service History table with the text "Confirmed".
This meant that any instance of that BookingID would have "Confirmed" in that field.
I'm trying to make this more useful by not excluding any activity that takes place after the date the booking was confirmed, as anything before confirmation is considered Sales activity, and any post is Service activity.
I have my new query as such:
What I need it to do is update the Ext Tool New Business Transaction field to be whatever the Activity Date is in the Qry Bookings to BK results.
I can't figure out how to do this, it only allows me to enter a blanket text to be updated on all BookingIDs, rather than a dynamic update based on the Activity Date in the Qry results.
Any ideas?
Thanks