Need Help Creating a calculations in a query

[Guest]

hello
I have a table with a feild named "Ethnic Group" which has a pull down menu
with various choices (ie. Latino, Caucasion). Im trying to create a query (in
design view):
1. Totals (sum or count?) of each Ethnic Group (ie.50 Latino, 50 Caucasion)
2. Calculate percentages of each Ethnic Group (ie. 50% Latino, 50% Caucasion)

Im creating a query in design view and cant seem to get the expressions
correct.
Any ideas? Thanks ;-)

 

[PC Datasheet]

In a query, you need the fields EthnicGroup and NumberInGroup. While in the
query design view, click on the Sigma button (looks like capital E) in the
toolbar at the top of the screen. Then change Group By under NumberInGroup
to Count. This gives you #1. In a blank field in the query, type in this
expression:
EthnicGroupPercent:[CountOfNumberInGroup]/DCount("*","[Ethnic Group"). This
column gives you #2.

 

[Guest]

Hi Again,
I did just what you suggested and I got stuck in two places:
1. It asks for a paramter value? I assumed this would be "latino" ect. It
doesnt work.
2. It says the expression is too long or typed incorrectly (I copied and
pasted what you suggested)
Any ideas?
Help is very much appreciated!!!!
;-)

In a query, you need the fields EthnicGroup and NumberInGroup. While in the
query design view, click on the Sigma button (looks like capital E) in the
toolbar at the top of the screen. Then change Group By under NumberInGroup
to Count. This gives you #1. In a blank field in the query, type in this
expression:
EthnicGroupPercent:[CountOfNumberInGroup]/DCount("*","[Ethnic Group"). This
column gives you #2.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

hello
I have a table with a feild named "Ethnic Group" which has a pull down
menu
with various choices (ie. Latino, Caucasion). Im trying to create a query
(in
design view):
1. Totals (sum or count?) of each Ethnic Group (ie.50 Latino, 50
Caucasion)
2. Calculate percentages of each Ethnic Group (ie. 50% Latino, 50%
Caucasion)

Im creating a query in design view and cant seem to get the expressions
correct.
Any ideas? Thanks ;-)

 

[PC Datasheet]

Post the SQL of your query.

Hi Again,
I did just what you suggested and I got stuck in two places:
1. It asks for a paramter value? I assumed this would be "latino" ect. It
doesnt work.
2. It says the expression is too long or typed incorrectly (I copied and
pasted what you suggested)
Any ideas?
Help is very much appreciated!!!!
;-)

In a query, you need the fields EthnicGroup and NumberInGroup. While in
the
query design view, click on the Sigma button (looks like capital E) in
the
toolbar at the top of the screen. Then change Group By under
NumberInGroup
to Count. This gives you #1. In a blank field in the query, type in this
expression:
EthnicGroupPercent:[CountOfNumberInGroup]/DCount("*","[Ethnic Group").
This
column gives you #2.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

hello
I have a table with a feild named "Ethnic Group" which has a pull down
menu
with various choices (ie. Latino, Caucasion). Im trying to create a
query
(in
design view):
1. Totals (sum or count?) of each Ethnic Group (ie.50 Latino, 50
Caucasion)
2. Calculate percentages of each Ethnic Group (ie. 50% Latino, 50%
Caucasion)

Im creating a query in design view and cant seem to get the expressions
correct.
Any ideas? Thanks ;-)

 

[Guest]

Hi,
I used what you suggested:

EthnicGroupPercent:[CountOfNumberInGroup]/DCount("*","[Ethnic Group")

Any ideas?
Thanks again so very much!

Post the SQL of your query.

Hi Again,
I did just what you suggested and I got stuck in two places:
1. It asks for a paramter value? I assumed this would be "latino" ect. It
doesnt work.
2. It says the expression is too long or typed incorrectly (I copied and
pasted what you suggested)
Any ideas?
Help is very much appreciated!!!!
;-)

In a query, you need the fields EthnicGroup and NumberInGroup. While in
the
query design view, click on the Sigma button (looks like capital E) in
the
toolbar at the top of the screen. Then change Group By under
NumberInGroup
to Count. This gives you #1. In a blank field in the query, type in this
expression:
EthnicGroupPercent:[CountOfNumberInGroup]/DCount("*","[Ethnic Group").
This
column gives you #2.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


hello
I have a table with a feild named "Ethnic Group" which has a pull down
menu
with various choices (ie. Latino, Caucasion). Im trying to create a
query
(in
design view):
1. Totals (sum or count?) of each Ethnic Group (ie.50 Latino, 50
Caucasion)
2. Calculate percentages of each Ethnic Group (ie. 50% Latino, 50%
Caucasion)

Im creating a query in design view and cant seem to get the expressions
correct.
Any ideas? Thanks ;-)

 

[Guest]

Hi again,
It says "Can not have aggregate function in expression"
after I do everything you suggested. ;-(

Post the SQL of your query.

Hi Again,
I did just what you suggested and I got stuck in two places:
1. It asks for a paramter value? I assumed this would be "latino" ect. It
doesnt work.
2. It says the expression is too long or typed incorrectly (I copied and
pasted what you suggested)
Any ideas?
Help is very much appreciated!!!!
;-)

In a query, you need the fields EthnicGroup and NumberInGroup. While in
the
query design view, click on the Sigma button (looks like capital E) in
the
toolbar at the top of the screen. Then change Group By under
NumberInGroup
to Count. This gives you #1. In a blank field in the query, type in this
expression:
EthnicGroupPercent:[CountOfNumberInGroup]/DCount("*","[Ethnic Group").
This
column gives you #2.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


hello
I have a table with a feild named "Ethnic Group" which has a pull down
menu
with various choices (ie. Latino, Caucasion). Im trying to create a
query
(in
design view):
1. Totals (sum or count?) of each Ethnic Group (ie.50 Latino, 50
Caucasion)
2. Calculate percentages of each Ethnic Group (ie. 50% Latino, 50%
Caucasion)

Im creating a query in design view and cant seem to get the expressions
correct.
Any ideas? Thanks ;-)

 

[Guest]

Thnaks for all your help so far.
Using your ideas I got my question to #1 to work perfectly! (I even figured
out how to narrow the seach ( design view)to include only specific fiscal
years. ;-)
Im still stuck on question #2 on creating the correct expression to
calculate the percentages instead of the totals. What you suggested doesnt
work. ;-(
EthnicGroupPercent:[CountOfNumberInGroup]/DCount("*","[Ethnic Group")
Any more ideas?

In a query, you need the fields EthnicGroup and NumberInGroup. While in the
query design view, click on the Sigma button (looks like capital E) in the
toolbar at the top of the screen. Then change Group By under NumberInGroup
to Count. This gives you #1. In a blank field in the query, type in this
expression:
EthnicGroupPercent:[CountOfNumberInGroup]/DCount("*","[Ethnic Group"). This
column gives you #2.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

hello
I have a table with a feild named "Ethnic Group" which has a pull down
menu
with various choices (ie. Latino, Caucasion). Im trying to create a query
(in
design view):
1. Totals (sum or count?) of each Ethnic Group (ie.50 Latino, 50
Caucasion)
2. Calculate percentages of each Ethnic Group (ie. 50% Latino, 50%
Caucasion)

Im creating a query in design view and cant seem to get the expressions
correct.
Any ideas? Thanks ;-)