T
Thomascl
Newbie - please be gentle...
I want to update a field [Master Balance]in a table [Vendors] based on Query
Results.
Here is my SQL that produces the data I want to store in the table:
SELECT DISTINCTROW [Sales Ticket].[Vendor ID], Sum([Sales Ticket].[Account
Balance]) AS [SumOfAccount Balance]
FROM [Sales Ticket]
GROUP BY [Sales Ticket].[Vendor ID];
I need to update the field [Master Balance] in the Vendors table for
each record in the Query that has a match based Vendor ID with the value
[SumOfAccount Balance].
I want to update a field [Master Balance]in a table [Vendors] based on Query
Results.
Here is my SQL that produces the data I want to store in the table:
SELECT DISTINCTROW [Sales Ticket].[Vendor ID], Sum([Sales Ticket].[Account
Balance]) AS [SumOfAccount Balance]
FROM [Sales Ticket]
GROUP BY [Sales Ticket].[Vendor ID];
I need to update the field [Master Balance] in the Vendors table for
each record in the Query that has a match based Vendor ID with the value
[SumOfAccount Balance].