This is the Access database Table name as report i need to sum the transaction count based on process name filter on this month.Process name as one variable and transaction count as another variable.and i need to update another table name BuinessAmount .
Filter based on process is in thiss table
Create a totals query on the Report table → group by ProcessName → sum TransactionCount → filter by current month then join this query with BusinessAmount on ProcessName. Update BusinessAmount.TransactionCount with the summed value then recalculate TotalBusinessValue = TransactionCount * Amount_Per_Transaction.
Cheers
i didnt get it sorry ..could you please explain
Hello @Vijayan_Sathyagiri_EXTERN,
- Filter & Sum:
a. We use Format(StartDate, "yyyymm") = Format(Date(), "yyyymm") to filter only records from the current month.
b. Then, we sum TransactionCount grouped by ProcessName.
- Update Table:
a. We update BusinessAmount.TransactionCount with the sum.
b. Calculate TotalBusinessValue using the formula.
You can connect to it using db activities and then use select queries to get the results you need
Cheers