Percentage Query

[RHomsey]

I am trying to create a query that will bring up a percentage.

We have grades for store locations (they are grades for grease traps). I need to be able to have some thing like this:

For (example) october .. 4% were A's
26% were B's
60% were C's
10% were D's
0% were F's

Is this possisble??

 

[EndersG]

Use this syntax in a query expression Format([FieldName],"Percent").

This will convert your final results (make sure the values are in 1/100th by using the Double number type)into a percentage.

 

[RHomsey]

Ok, so i have a query that pulls these records. Where is the query expression format entered at?? Sorry, i forgot to put im a total newb and do not understand access very well.

 

[RHomsey]

**BUMP**

 

[RHomsey]

Can someone please help me on this?

 

[indyaries]

Greetings,

Presuming the name of your field is Grade, this is what would be in the query grid:

Grade:Format([Grade],"Percent")

HTH

 

[EndersG]

RHomsey,

Go to the design grid of your queryand add the table or query that has the field values you want to convert to a percentage. Then add a field called Answer (or whatever you want to call it) that will hold the final result. Check the jpg I've attached as an example...

 

[RHomsey]

Thanks a bunch .. That helps me out a lot .. The jpg really made it clear how simple what it is you were saying. **appluades**Thanks again