Search results

I agree that in general you should not store calculated values, however there are times when this is appropriate. For example, when you need summaries on a huge table with complicated calcs or when you are trying to work around other limitations of Access. Keith, I am right there with you on...

Update: I got it to work! It does not show up right in report view but when I switch to print preview, it works!

I am having a similar issue (possibly the same?) whenever I open a form in 2003 it asks me to enter parameters. The parameters asked for are the references that I had entered. In my case, the references are in the query that populates the sub-form. Some of the references point to the parent form...