database query problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a formula/query using fields from a main and a subform
to calculate the percentage of penetration by dividing the number of students
tested by the total number of students. I keep getting the following error
message: #Name?

The formula I am using is: =[Total Jr/Sr
Tested]/([Forms]![Population]![Total Jr/Sr])

Any suggestions?

Thanks
 
For a subform field use the following syntax
[forms]![mainform]![subform]![fieldname]. Name? means it cannot find field
named.
 
It looks like you haven't named the subform in your reference. Reference
should look like:

Forms![Main Form Name]![Subform Name]![Name of control on subform].[property]

You left out one level of specification.
 
Back
Top