counting

G

Gabi

In my report, I want to include the % of occurrence of "6" in the variable
"rating". I think DCount is the function to use, but what is the proper
expression?

Thanks for your advice.
 
G

Gabi

Thanks. I still got an #Error on my report. I know it's hard for you guys
to diagnose with so little information, but any guess what could have gone
wrong?

Thanks.

Roger Carlson said:
Try:

=Format(DCount("rating", "YourTable", "[rating]='6'")/DCount("rating",
"YourTable"),"percent")

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


Gabi said:
In my report, I want to include the % of occurrence of "6" in the variable
"rating". I think DCount is the function to use, but what is the proper
expression?

Thanks for your advice.
Click to expand...
Click to expand...
 
G

Gabi

Okay, I got it through fine. But I have more question:
My report is based on a query, that select a portion of the table to
summarize. I put in the DCount expression in the query box, but it seems to
be counting the whole table rather than the selection. My "Avg" in the query
works fine.

Thanks for your advice and help.


Gabi said:
Thanks. I still got an #Error on my report. I know it's hard for you guys
to diagnose with so little information, but any guess what could have gone
wrong?

Thanks.

Roger Carlson said:
Try:

=Format(DCount("rating", "YourTable", "[rating]='6'")/DCount("rating",
"YourTable"),"percent")

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


Gabi said:
In my report, I want to include the % of occurrence of "6" in the variable
"rating". I think DCount is the function to use, but what is the proper
expression?

Thanks for your advice.
Click to expand...
Click to expand...
Click to expand...
 
R

Roger Carlson

Make sure your report is based on a saved query and then use that name in
the "table" section of the DCount.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


Gabi said:
Okay, I got it through fine. But I have more question:
My report is based on a query, that select a portion of the table to
summarize. I put in the DCount expression in the query box, but it seems to
be counting the whole table rather than the selection. My "Avg" in the query
works fine.

Thanks for your advice and help.


Gabi said:
Thanks. I still got an #Error on my report. I know it's hard for you guys
to diagnose with so little information, but any guess what could have gone
wrong?

Thanks.

Roger Carlson said:
Try:

=Format(DCount("rating", "YourTable", "[rating]='6'")/DCount("rating",
"YourTable"),"percent")

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


In my report, I want to include the % of occurrence of "6" in the variable
"rating". I think DCount is the function to use, but what is the proper
expression?

Thanks for your advice.
Click to expand...
Click to expand...
Click to expand...
 
Top