Create percentage from column names

[Brian62]

I am trying to create a percentage of the (yeses and N/A) / (No's). There are 22 column names from another query.



This is what I have tried in my query by I should be in the high 90% range instead of 4%.

Yes: Sum([Doc2Y]+[Doc12-5Y]+[Doc25Y]+[Doc30y]+[Doc36y]+[MemoY]+[Doc19Y]+[Doc25-7Y]+[Doc26Y]+[Doc27Y]+[Doc32-2Y]+[SRSY]+[Doc44-2Y]+[ProjectsY]+[AbstractY]+[Doc34-9Y]+[Doc35Y]+[Doc37Y]+[ProtocolsY]+[Doc32Y]+[Doc49-2Y]+[Doc11-5Y])/("100")

I have another one just like this but for the no's.

Example: 20 yeses or N/A's of 22 column names subtracting 2 No column names should give me 91%.

Is there a way that I can do this in a query that will show on my report?

[ajetrumpet]

somebody who can post messages this fast, shouldn't need to ask about technology. You can probably google it faster than waiting for an answer, even from the fastest programmer on earth.

[Brian62]

I spent over 2 hours googling and did not find the answer I was looking for. I always try that first before posting....

[ajetrumpet]

good for you.

you may not get an answer either place, because the ? is not really that clear. what do you need exactly?

It's probably my old age, as others are probably looking at this and thinking it's clear as a bell!

[Brian62]

Think of it as an Excel spreadsheet that will calculate the percentage for you. This is much like that.

When I use the sum() it does give me the total of all the yeses and N/A's for all the columns. I got it to add in by columns but now I need it to divide into a percentage.

The field names are actually document numbers. It is a checklist that I have created and need to calcualte the percentage when sending it up the chain.

I forgot to mention that it will also have to divide it by 10 records that I audit each month on top of what I already mentioned. Didn't think about it until I left for the day. (Brain fart)!

The 91% would be from one Audit.