Percent Queries

[jmthompson]

Hi! I am just plain stuck. I am trying to run a query to show me percents of different fields let say I have Contact method of 6 diff types and I want to run a percent on the use. How can i get this done I have tried a couple of ways and I just cannot get it figured out. Please Help!!!

 

[r937]

without seeing your query it's hard to guess

  select contact1 * 100 / 
         (contact1+contact2+contact3 
         +contact4+contact5+contact6 ) as percenta

rudy

 

[jmthompson]

Thank you very much for your reply. Here is what my query looks like I have a section in my form that is called contact method choices are email, phone, walk over etc.. There are 6 of them. Well when I do my query first I get my count of how many have been used (broken down for each one). Next from this count I want to get a percent of the usage. I have still confused as to how to do this I am a novice when it comes to access.