I may have to modify my previous question. I have a field in the database type1sqyds--which is a calculated field--I actually have the formula/expression on the property list on the control source row. This seems to be working for me...with one issue results. When I try to use the field in a report is shows blank? Everything I've read said to have a calculated field with a query. When I tried that-- on the view of the form the field turned into a pull down field...where you had to use the pull to get the correct results. That was not exceptible. If this is making any sense will someone give me a working solution? Thanks in advance.
Our community of experts have been thoroughly vetted for their expertise and industry experience.