Query

[Guest]

I have several fields in my query. i am trying to write this formula
([nMLO]<2) / (total of the xFin column). Ill try and explain this the best I
can. nMLO<2 as a field should be ok.-----I have another field xFin. I set it
to xFIN=1 If I can figure a way to add up all the ones in that field, then I
could use that total in the formula above. If i confused you please say so
and i will try and explain myself better.
-- Im trying to divide mlo<2 by the total number of xfin. Sure hope someone
could help me. I sure would save me a lot of time.
thanks
ed

 

[Duane Hookom]

Sorry but this is a bit difficult to understand. What do you expect from the
expression ([nMLO]<2)? Are you expecting to count the number of records
where nMLO is greater than 2? Do you want to divide this number by number of
records in your table where the value of xFin equals 1?

 

[Guest]

WOW!!!!!!!!!!! I didnt think I would get help this soon. [nmlo]<2 with this
expression i am trying to count the number of records in nmlo who are below
2. The numbers in there will range from 0 to 100.---xfin I would like to
count the number of records in xfin. All the numbers in there will be ones,
but i need there total. Then I would like to divide the number of records in
nmlo by the the number of records in xfin.
What im trying to do in my query is determine the percentage of horses who
nmlo are below 2. xfin is what i choose to determine the total number of
records in this query. I didnt know how else to determine the total number of
records in this query.
So if there are 100 records in this query and 20 have nmlo<2, Manually I
would divide 20/100= 20% I do this for about 15 similar records. It becomes
quite time consuming. I sure appreciate any help ypu you give me. If I still
didnt express myself clearly please dont give up. just say so and Ill try
again.
thanks ed
--
thanks

Sorry but this is a bit difficult to understand. What do you expect from the
expression ([nMLO]<2)? Are you expecting to count the number of records
where nMLO is greater than 2? Do you want to divide this number by number of
records in your table where the value of xFin equals 1?

--
Duane Hookom
MS Access MVP

I have several fields in my query. i am trying to write this formula
([nMLO]<2) / (total of the xFin column). Ill try and explain this the best
I
can. nMLO<2 as a field should be ok.-----I have another field xFin. I set
it
to xFIN=1 If I can figure a way to add up all the ones in that field, then
I
could use that total in the formula above. If i confused you please say so
and i will try and explain myself better.
-- Im trying to divide mlo<2 by the total number of xfin. Sure hope
someone
could help me. I sure would save me a lot of time.
thanks
ed

 

[Guest]

Duane
I hope you have time to take another look at this.
--
thanks

Sorry but this is a bit difficult to understand. What do you expect from the
expression ([nMLO]<2)? Are you expecting to count the number of records
where nMLO is greater than 2? Do you want to divide this number by number of
records in your table where the value of xFin equals 1?

--
Duane Hookom
MS Access MVP

I have several fields in my query. i am trying to write this formula
([nMLO]<2) / (total of the xFin column). Ill try and explain this the best
I
can. nMLO<2 as a field should be ok.-----I have another field xFin. I set
it
to xFIN=1 If I can figure a way to add up all the ones in that field, then
I
could use that total in the formula above. If i confused you please say so
and i will try and explain myself better.
-- Im trying to divide mlo<2 by the total number of xfin. Sure hope
someone
could help me. I sure would save me a lot of time.
thanks
ed

 

[Duane Hookom]

I believe I saw this same question in another thread. That is not a good
idea. This is my last post in this thread in hopes that all future replies
will be in the other thread of the same question.

It still isn't clear if you expect just one number from this query or if
there should be other fields and records. A WAG suggests a query like:

SELECT (Select Count(*) from [SomeTableQuery] q WHERE q.Nmlo<2)/(Select
Count(*) From xfin) As YourNumber
FROM SomeTableQuery;

This may lack any semblance to what you need.
--
Duane Hookom
MS Access MVP

WOW!!!!!!!!!!! I didnt think I would get help this soon. [nmlo]<2 with
this
expression i am trying to count the number of records in nmlo who are
below
2. The numbers in there will range from 0 to 100.---xfin I would like to
count the number of records in xfin. All the numbers in there will be
ones,
but i need there total. Then I would like to divide the number of records
in
nmlo by the the number of records in xfin.
What im trying to do in my query is determine the percentage of horses who
nmlo are below 2. xfin is what i choose to determine the total number
of
records in this query. I didnt know how else to determine the total number
of
records in this query.
So if there are 100 records in this query and 20 have nmlo<2, Manually I
would divide 20/100= 20% I do this for about 15 similar records. It
becomes
quite time consuming. I sure appreciate any help ypu you give me. If I
still
didnt express myself clearly please dont give up. just say so and Ill try
again.
thanks ed
--
thanks

Sorry but this is a bit difficult to understand. What do you expect from
the
expression ([nMLO]<2)? Are you expecting to count the number of records
where nMLO is greater than 2? Do you want to divide this number by number
of
records in your table where the value of xFin equals 1?

--
Duane Hookom
MS Access MVP

I have several fields in my query. i am trying to write this formula
([nMLO]<2) / (total of the xFin column). Ill try and explain this the
best
I
can. nMLO<2 as a field should be ok.-----I have another field xFin. I
set
it
to xFIN=1 If I can figure a way to add up all the ones in that field,
then
I
could use that total in the formula above. If i confused you please say
so
and i will try and explain myself better.
-- Im trying to divide mlo<2 by the total number of xfin. Sure hope
someone
could help me. I sure would save me a lot of time.
thanks
ed