How can I Calculate % from 2 subforms?

[markvan]

I have 2 subforms
subfrmContactsInACell
subfrmContactsNotInACell
These are built on queries to count the records
The subforms have the purpose of displaying the record count
using =Count([ContactID])

Where do I go from here?
I have tried an unbound field with the source set to
=100/(Count([ContactsInACell].[ContactID])+(Count([ContactsNotInACell].[ContactID])* Count([ContactsInACell].[ContactID])
I keep getting errors?

In fact I can't even get it to display a result for
=Count([ContactsInACell].[ContactID])
which is probably where my problem begins. I must be missing something?

Help me please, TIA!

 

[Ziggurat]

Hi Markvan,

I am not quite sure what you are trying to do !!

Do you have text boxes on the subforms that are showing the count values ?

If yes then what are the names of these text boxes.

It should be just a simple case of getting the correct scope to these text boxes.

I also noticed that you subform name and the scope that you are using is not the same. What is the name of the subforms on the form.

eg [subfrmContactsInACell].[Your Text Box Name]

HTH

*
***
*****
Ziggurat