K
KB
Have a calculated field in a form. Works fine until i try to do a filter on
the data then the field shows #Error instead of the total. Dont know why
this does not work. The Northwindproject sample database has something
similar in their Orders form and it works. Checked everything in my
database the syntax is correct and works as long as i dont filter,
unfortunutely the end user needs this to work with the filter. (Works in
the old Access form) Anybody have idea whats going on and how i can fix
this?
the data then the field shows #Error instead of the total. Dont know why
this does not work. The Northwindproject sample database has something
similar in their Orders form and it works. Checked everything in my
database the syntax is correct and works as long as i dont filter,
unfortunutely the end user needs this to work with the filter. (Works in
the old Access form) Anybody have idea whats going on and how i can fix
this?