Query Calculation

[Trisha]

I have a query that has a simple calculation in it (Per
Period: [Total Usage]/18), the only problem is, the number
18 will change, so I created a form that allows the person
to change this value. I know have it referenced in the
same query through a field (Per Period: [Total Usage]/
[NbrCalcPeriods]). However, when running it both ways I
get different results. The value in the field
NbrCalcPeriods is still 18 at this point for testing
reasons. If anyone can help me figure out why this would
be it would be greatly appreciated. I'm having so many
problems with such a simple thing. By the way, there are
4 tables in this query that are all linked together.

Thanks for the help!
Trisha

 

[GVaught]

You might try creating an individual query that counts the Calc Periods and
then use this query in with your other query to use. Note you may or may not
have to add the primary key to this separate query in order to keep the
relationship.

If this does not work. Give us a bigger picture with the # of tables and
structure of those tables you are using in the query where Per Period is
being used.