Hello, I have the question for you. I am creating a simple rental movie
database for my class. I already have created tables and quary with
formulars to calculate the late fees. Now I have to create a form with
fields, one of each has to be the amount due. I have this field in query,
but when I attach it to form it doesn't calculate the information like
query does. Do you know how can I make calculations work in the form?
Thank you
 

---

Answer from Richard Rost:

I would need to know more information about exactly WHAT you're trying to calculate and how your form fields are set up. I have a feeling, however, that you might want to use calculated QUERY fields instead of form fields. See this tutorial and let me know if you need more help:

It sounds to me like you just need to learn how to properly create CALCULATED QUERY FIELDS. You can make a query that will perform math operations for you automatically.

Please see the following FREE video tutorial on my web site for step-by-step instructions on how to create calculated query fields:

http://599cd.com/tips/access/calculated-query-fields?key=BlFAlEx