I was using 2002 and this worked just fine. Not sure why it wont work in 2003.
I have need to calculate a weighted averages for groups of records. The front end form allows the user to filter the list based on five different filters, each within a dropdown box. Any time one of the drodown boxes changes, I refilter the form by building a "where" string and injecting the chosen filters from each down down box.
In the query behind the form, I had a DSUM() which used Form!myForm.Filter as the where condition to calculate the Total figure to be used in the denominator for calculating the weight of each record. ie.
TotalBalance: DSUM("Balance", "Accounts", Form!myForm.Filter)
Weight:Balance/TotalBalance
This is isnt working anymore. Now Access pops up a dialog asking for Form!myForm.Filter before it will execute the query.
Anyone know whats wrong? Or is there a better way to calculate weighted averages?
I have need to calculate a weighted averages for groups of records. The front end form allows the user to filter the list based on five different filters, each within a dropdown box. Any time one of the drodown boxes changes, I refilter the form by building a "where" string and injecting the chosen filters from each down down box.
In the query behind the form, I had a DSUM() which used Form!myForm.Filter as the where condition to calculate the Total figure to be used in the denominator for calculating the weight of each record. ie.
TotalBalance: DSUM("Balance", "Accounts", Form!myForm.Filter)
Weight:Balance/TotalBalance
This is isnt working anymore. Now Access pops up a dialog asking for Form!myForm.Filter before it will execute the query.
Anyone know whats wrong? Or is there a better way to calculate weighted averages?
