Calculating percentage's

[Daan den Hollander via AccessMonster.com]

Goodday,

I have a query containing the following fields:
Categorie
CountofCategorie (Totals per Categorie)
Percentage: [CountofCategorie]/[CountOfID]
CountofID (Total no of records in the DBase (calculated in another query)

I have three questions:

- Why do I get a pop-up where I need to enter a value for CountofCategorie?
How do I supress it? (If I press enter I get the output I want)
- Can I get the total no. of records in another way so I don't need the
extra query?

Thanks

 

[Daan den Hollander via AccessMonster.com]

Oh by the way the pop-up is a Enter Parameter Value-popup

I set the format properties for all fileds except the Categorie-field

Ciao