No. If you are familiar with SQL, think about how queries pull data - you get every value for every field you have in your select statement, regardless of the table the value comes from.
However, there are a couple of ways around this. For both of these you'll group on the Account number from the Access database.
1. Use a Running Total field to sum the annual numbers that evaluates on change of Account Number.
2. Create a formula that looks something like this:
If PreviousIsNull({access_table.account}) or {access_table.account} <> previous({access_table.account}) then {access_table.annual_budget} else 0
You should then be able to sum this formula.
-Dell
IP Logged
