Hello:
It's been 19 years since I've used access and I've completely forgotten all of the query functions. I have a link table (from excel of course) with over 30k rows, so I want to use the processing power of access to do the calculations.
So here's what I have:
A table with multiple fields, one of which is an amount field (numeric value of course).
I have a query started, however I need to do a "SUMIFS" calculation.
Field names to total on are (the "IFS" part):
Job Number
Account
The total is in the "Amount in local currency" field (the "SUM" part).
I need to get the total by job and account and then output that in to a report (so I can export that back to excel). I tried the "Dsum" function in the "Criteria" of both a new "blank" field and in the "Amount in local currency" field, but got quite a few errors (after 19 years I thought I might!!).
Any assistance would be greatly appreciated.
I know this should be simple, but I don't know exactly how to tell MS Access to perform this calculation.
Thanks!!
It's been 19 years since I've used access and I've completely forgotten all of the query functions. I have a link table (from excel of course) with over 30k rows, so I want to use the processing power of access to do the calculations.
So here's what I have:
A table with multiple fields, one of which is an amount field (numeric value of course).
I have a query started, however I need to do a "SUMIFS" calculation.
Field names to total on are (the "IFS" part):
Job Number
Account
The total is in the "Amount in local currency" field (the "SUM" part).
I need to get the total by job and account and then output that in to a report (so I can export that back to excel). I tried the "Dsum" function in the "Criteria" of both a new "blank" field and in the "Amount in local currency" field, but got quite a few errors (after 19 years I thought I might!!).
Any assistance would be greatly appreciated.
I know this should be simple, but I don't know exactly how to tell MS Access to perform this calculation.
Thanks!!