Calculate Percentage

J

Jessica

I need a formula that would calculate the percentage of clients who have been
in a homesless shelter less then than twelve months who have no more than two
placements settings.I Have the following fields in a query. DOE and # of
placements. Can someone help me
 
A

Arvin Meyer [MVP]

Jessica said:
I need a formula that would calculate the percentage of clients who have
been
in a homesless shelter less then than twelve months who have no more than
two
placements settings.I Have the following fields in a query. DOE and # of
placements. Can someone help me

SELECT Count(tblMyTable.[# of placements]) AS PlacementCount
FROM tblMyTable
WHERE (((tblMyTable.DOE) Between Date() And Date()-365))
HAVING (((Count(tblMyTable.[# of placements]))>=2));

Where tblMyTable is the name of your table.
 
J

Jessica

Arvin,

I'm doing something wrong the formula is not working here it is
Count([# of placements]) PlacementCountFROMWHERE (((DOE) Between Date() And
Date()-365))HAVING ((([# of placements]))>=2));

Arvin Meyer said:
Jessica said:
I need a formula that would calculate the percentage of clients who have
been
in a homesless shelter less then than twelve months who have no more than
two
placements settings.I Have the following fields in a query. DOE and # of
placements. Can someone help me

SELECT Count(tblMyTable.[# of placements]) AS PlacementCount
FROM tblMyTable
WHERE (((tblMyTable.DOE) Between Date() And Date()-365))
HAVING (((Count(tblMyTable.[# of placements]))>=2));

Where tblMyTable is the name of your table.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
A

Arvin Meyer [MVP]

This is a query, not a formula. You open a new query, go to SQL view, then
paste in my SQL statement. If you have put in the correct field names and
table names, just save it and run it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Jessica said:
Arvin,

I'm doing something wrong the formula is not working here it is
Count([# of placements]) PlacementCountFROMWHERE (((DOE) Between Date()
And
Date()-365))HAVING ((([# of placements]))>=2));

Arvin Meyer said:
Jessica said:
I need a formula that would calculate the percentage of clients who have
been
in a homesless shelter less then than twelve months who have no more
than
two
placements settings.I Have the following fields in a query. DOE and #
of
placements. Can someone help me

SELECT Count(tblMyTable.[# of placements]) AS PlacementCount
FROM tblMyTable
WHERE (((tblMyTable.DOE) Between Date() And Date()-365))
HAVING (((Count(tblMyTable.[# of placements]))>=2));

Where tblMyTable is the name of your table.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
J

Jessica

I'm typing it exactly as i was given the formula, and an error message is
coming up where the AS Placement Count Command is at.

Count([OOH]!.[# of placements]) AS PlacementCount
FROM OOH
WHERE ([OOH]![DOE]) Between Date() And Date()-365))
HAVING (((Count([OOH]![# of placements]))>=2));


Arvin Meyer said:
This is a query, not a formula. You open a new query, go to SQL view, then
paste in my SQL statement. If you have put in the correct field names and
table names, just save it and run it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Jessica said:
Arvin,

I'm doing something wrong the formula is not working here it is
Count([# of placements]) PlacementCountFROMWHERE (((DOE) Between Date()
And
Date()-365))HAVING ((([# of placements]))>=2));

Arvin Meyer said:
I need a formula that would calculate the percentage of clients who have
been
in a homesless shelter less then than twelve months who have no more
than
two
placements settings.I Have the following fields in a query. DOE and #
of
placements. Can someone help me

SELECT Count(tblMyTable.[# of placements]) AS PlacementCount
FROM tblMyTable
WHERE (((tblMyTable.DOE) Between Date() And Date()-365))
HAVING (((Count(tblMyTable.[# of placements]))>=2));

Where tblMyTable is the name of your table.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
A

Arvin Meyer [MVP]

Where is the SELECT statement?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Jessica said:
I'm typing it exactly as i was given the formula, and an error message is
coming up where the AS Placement Count Command is at.

Count([OOH]!.[# of placements]) AS PlacementCount
FROM OOH
WHERE ([OOH]![DOE]) Between Date() And Date()-365))
HAVING (((Count([OOH]![# of placements]))>=2));


Arvin Meyer said:
This is a query, not a formula. You open a new query, go to SQL view,
then
paste in my SQL statement. If you have put in the correct field names and
table names, just save it and run it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Jessica said:
Arvin,

I'm doing something wrong the formula is not working here it is
Count([# of placements]) PlacementCountFROMWHERE (((DOE) Between Date()
And
Date()-365))HAVING ((([# of placements]))>=2));

:

I need a formula that would calculate the percentage of clients who
have
been
in a homesless shelter less then than twelve months who have no more
than
two
placements settings.I Have the following fields in a query. DOE and
#
of
placements. Can someone help me

SELECT Count(tblMyTable.[# of placements]) AS PlacementCount
FROM tblMyTable
WHERE (((tblMyTable.DOE) Between Date() And Date()-365))
HAVING (((Count(tblMyTable.[# of placements]))>=2));

Where tblMyTable is the name of your table.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top