comment calculer entr deux limite dans access 2010 (1 Viewer)

[zibou]

comment calculer entre deux limites dans access 2010

Bonjour tout le monde .

dans ma table il y a un champ "" MOYENNE ""
la Question est ......
COMMENT CALCULER (( COMBIEN D'ÉLEVÉS AYANT LA MOYENNE ENTRE DEUX VALEUR ))
PAR EXEMPLE .

entre " 0 - 4,99 " ........ 04 élevés

J'AI ESSAYE LA formule (( entre 0 ET 4,99 )) en vain

et moyenne >=0 Et moyenne <=4,99
MAIS RIEN.

ce que je veux qu'il s'affiche ...........

entre " 0 - 4.99 " ............. (( 10 élevés))
entre " 5 - 9.99 " ..............(( 15 élevés ))

alors, c'est une formule qui se répète a chaque fois avec d'autre valeur


merci beaucoup

 

[John Big Booty]

From bable Fish;

Hello everyone. in my table there is a field " " AVERAGE " " 
the Question is ...... HOW TO CALCULATE ((HOW MUCH D' RAISED HAVING THE AVERAGE BETWEEN TWO VALUE)) 
FOR EXAMPLE. between " 0 - 4,99 " ........ 04 high J' AI TESTS 
the formula ((between 0 AND 4,99)) in vain and average > =0 And average

what I want qu' it s' post ........... 
between " 0 - 4.99 " ............. ((10 high)) 
between " 5 - 9.99 " .............. ((15 high)) 
then, c' is a formula which is repeated each time with d' another value

 thank you very much

 

[boblarson]

Posts at this forum should be in English.

Messages dans ce forum devrait être en anglais.

 

[Simon_MT]

Bob,

This is a co.uk forum and American's, Aussie's, Canadians and the odd kiwi are allowed. Yes, it would be helpful to have threads in English and perhaps for foreign speakers whose English is not good, don't be rude, they could try google translate just as I have:

http://translate.google.com/#fr|en|

Simon

Zibou

Pourriez-vous après votre base de données de telle sorte que nous pouvons vous aider.

Merci beaucoup

Simon

 

[boblarson]

Bob,

This is a co.uk forum and American's, Aussie's, Canadians and the odd kiwi are allowed. Yes, it would be helpful to have threads in English and perhaps for foreign speakers whose English is not good, don't be rude, they could try google translate just as I have:

http://translate.google.com/#fr|en|

Simon

Zibou

Pourriez-vous après votre base de données de telle sorte que nous pouvons vous aider.

Merci beaucoup

Simon

I used Google Translate for the response I had. And it isn't rude to let the user know that the posts need to be in English and they can go use the translation software if they wish, but the board is officially an English Language board and as such we can request that the posts be made in English.

 

[Simon_MT]

I was only suggesting that my own spelling and grammar is sometimes somewhat lackadaisical so being in French might be more understandable than some of my own efforts.

I wasn't being offensive as you have corrected me in the past.

Simon

 

[ChrisO]

Is this site intended for English only?
I can not find such a reference so if anyone else can then please post a link.

I’m thinking that restricting the site to just English can only decrease site hits and may reflect in a decrease in site advertising revenue.

Maybe Jon has said something about it, I don’t know???

Chris.

 

[Dairy Farmer]

This is a co.uk forum and American's, Aussie's, Canadians and the odd kiwi are allowed.

Well there's the problem. You let the Aussies and Kiwis in. What about us Saffers?

ÉLEVÉS = pupils or students

I think the OP want a formula that calculates how many pupils have a average between 0 and 4.99 and how many have an average between 5 and 9.99

So the question is:

I have a field in a table called "Average"
How do I calculate how many pupils have an average between 0 and 4.99 and 5 and 9.99.

Answer:
Use a query (requête) with DCount

SELECT DISTINCT DCount("[Average]","Table1","[Average]<5") AS Field1, DCount("[Average]","Table1","[Average]>=5") AS Field2
FROM Table1;

Field1: DCount("[Average]","Table1","[Average]<5")
Field2: DCount("[Average]","Table1","[Average]>=5")

 

[zibou]

yes you said it all. Forgive me. I speak little English. so I'm always afraid of not properly expressed.
and thank you very much for your reply so fast.

in my table there is a field "AVERAGE"
Question is ......
HOW TO CALCULATE HOW MANY STUDENTS BETWEEN THE AVERAGE ""0 - 4.99 "EG.

I HAVE TRIED THE PUBLIC ((0 to 4.99)) in vain
and THANK YOU VERY MUCH.

1 - No.
2 - Name
3 - assessment score
4 - duty 1
5 - Duty 2
6 - Average duty
7 - Composition
8 - Quarterly Average
9 - Average X Factor
10- Statistics

So I must make the statistical averages .....

a-How many students with the average of "0 - 4.99"
b-how many students with the average of "5 - 9.99"
c-................ "6 - 9.99"
d ....................... .
e .....

Extra

Thqnkyou very very mush

 

[Galaxiom]

Avoid using Domain functions in a query. Each instance of the DCount is in essence a query making it incredibly slow.

Derive a field that allocates each record to a bin using the Switch function.
http://www.techonthenet.com/access/functions/advanced/switch.php

Then Group By and Count this field.

 

[zibou]

From bable Fish;

Hello everyone. in my table there is a field " " AVERAGE " " 
the Question is ...... HOW TO CALCULATE ((HOW MUCH D' RAISED HAVING THE AVERAGE BETWEEN TWO VALUE)) 
FOR EXAMPLE. between " 0 - 4,99 " ........ 04 high J' AI TESTS 
the formula ((between 0 AND 4,99)) in vain and average > =0 And average

what I want qu' it s' post ........... 
between " 0 - 4.99 " ............. ((10 high)) 
between " 5 - 9.99 " .............. ((15 high)) 
then, c' is a formula which is repeated each time with d' another value

 thank you very much

THANKYOU VERY MUCH

I want to KNOW that's all. and work

Humanizes the monkey is better than a bright moon

 

[gemma-the-husky]

you could try a query using the function "PARTITION"

bon annee.

 

[MarkK]

I object to discrimination on the basis of language. This is a public place and what language is spoken here should remain the choice of the speakers.

 

[boblarson]

I object to discrimination on the basis of language. This is a public place and what language is spoken here should remain the choice of the speakers.

Pagtutol kilala ngunit ito ay hindi baguhin ang katunayan na ito ay isang Ingles board wika at laging ay. Posters ay libre upang bisitahin ang iba pang boards na sa kanilang sariling wika at ay hindi kailangan upang mag-post dito.

 

[Rabbie]

I object to discrimination on the basis of language. This is a public place and what language is spoken here should remain the choice of the speakers.

While I am opposed to discrimination on the basis of race, language etc I think people will find they get a speedier and more helpful response if they post in a language understood by the majority of forum users.

 

[gemma-the-husky]

nothing like a pleasant start to the new year.

and this is nothing like a pleasant start ....

 

[boblarson]

nothing like a pleasant start to the new year.

and this is nothing like a pleasant start ....

It is a remnant of the old year (27 Dec 2010) so it doesn't count for this year.

 

[gemma-the-husky]

I didn't see the issue

if someone can help answer a query in french, or any other language, great. if not then too bad. I don't think it will become a regular occurrence.

occasionally you see field names in german/dutch etc - which i also find very difficult to deal with - its hard when you don;t understand the sense of what's being asked.

by the way, what was the language you were using at the end there, bob?

 

[Dairy Farmer]

I speak multiple languages. French is not one of them. But a simple translation to English was not that hard using the internet.

If a person asks a question in, say, French. Let it be translated into English correctly before all the flaming starts. But the OPs must be made aware that the language of choise is English (proper English or American, doesn't matter). If another language is used then the OP must expect some delay in answering.