Calculating Percentage using DCount? HELP!! (1 Viewer)

[mateogp]

Heya All,

I need some help. I need to beable to calculate percentage based on the number of records that store a certain value. Say a marketing lead is "Yellow Pages". I need to beablet to find all the instances of the yellow pages, and divide it by the total number of records to get a percentage.

This one worked in the query:
Answer: Round((DCount("Marketing","BridalDelete","Marketing='Fashion Show'")/DCount("*","BridalDelete"))*100,2)

But it will not work in the control source of a text box. How do I convert the query style code to form/report view?

This is what I use for the text box’s control source for just counting:

=DCount("[Marketing]","BridalDelete","Marketing='Yellow Pages'")

This one works on in querys only:

Answer: Round((DCount("Marketing","BridalDelete","Marketing='Fashion Show'")/DCount("*","BridalDelete"))*100,2)

I tried to modify it to make it work, but it just automatically deletes the last part.

=DCount(“[Marketing]”,”BridalDelete”,”Marketing=’Yellow Pages’”)/DCount("*","BridalDelete"))*100,2)


How do I convert it to form/report view?

Any help would be majorally appreciated, its driving me nuts and the boss would like this done ASAP (along with 5,000 other projects)

Mateo