Recent content by Novaember

Sorry I'm not getting it. Where do I put this conditional formatting? On the form? on the table for the drop down list? thanks! :)

Hello I have a form that the user fills out. There are drop downs where for items they select YES, NO, NAA, NA, FYI. Is there a way to make it so that when they select NO that box on the form displays in red? All other selections would be the normal white color, but if they select NO it...

Hi I'm completely stumped (as usual) I'm trying to calculate the accuracy rate by analyst by month. I can easily calculate it one month at a time. What I need is to create a graph on a report that shows accuracy rate by month and I think my queries are bad. I think I need one query that...

Brilliant :) Worked like a charm! Thanks so much! Nova Also I have the Nz on the other queries that give me totalItems and TotalIncorrectItems. So if those are null it delivers a zero to me. Thanks so much!

Hello I have some queries that run and total items. Then when I get those items I calculate an accuracy rate and a defect rate. The formula is: AccuracyRate: 1-([TotalIncorrectItems]/[totalItems]) However I run into a problem when TotalIncorrectItems and totalItems are both zero. What do...

Ahhhh! I figured it out! AccuracyRatePlus1: FormatPercent(IIf([STDevAccuracyRatePlus1]>100,1,[STDevAccuracyRatePlus1])) that always happens I'm puzzled forever and 10 minutes after I post here I figure it out! lol

Hi When I put that in the result displayed is the word Percentage It also puts in lots of extra quotes around the word Percentage when I save it. When I enter it there is only one set of quotes around the word Percentage and when I go back to review it after saving there are 3 sets...

Hello I am calculating the accuracy rate and the accuracy rate standard deviations +1, +2, -1 and -2. My AccuracyRate is 95.16% The STDevAccuracyRate is 3.76% (i display these as a percentage) When I calculate the Accuracy Rate plus 1 standard deviation (STDevAccuracyRatePlus1) I get 98.92%...

Hi This might sound stupid but I am very new at Access. I see I can make an ACCDE file that will keep anyone from tampering with my queries etc. Which is awesome. But what if I need to change something or add a new query or report. I can make my changes in the regular database but the ACCDE...

Omg look! This is like the most ghetto way to doing it but it works so w/e ProdPlus1: IIf([STDevplus1]-100<1,"100%",[STDevplus1]) That doesn't look like it should work but it does.. so awesome. Thanks!!

Yes I have the Accuracy Rate calculated - that is a calculated value in a query. (queryProdAnalystAccuracyRate) Then I have another query that takes that calculated value and finds the Standard Deviation. (queryProdAnalystSTDev) And then another query that uses the Accuracy Rate and either +...

I'm just using the STDev function that is built into access. the calculations are correct (I compared them to what I get in Excell) it i just the display that I need help with. I don't want anything to display over 100%

Hello I have a quality database and I calculated the standard deviation for my accuracy rate. I have calculated: the accuracy rate + 1 standard deviation (STDevplus1) the accuracy rate + 2 standard deviations (STDevplus2) the accuracy rate - 1 standard deviation (STDevminus1) the accuracy...

Hello! I have a quality database where items are scored for quality purposes. I also have a query that calculates how many items are in the sample, how many opportunities there are for a defect, how many defects there are etc. That works great when I am running that for the entire process...

duh nevermind! lol amazing what lunch and a short walk will accomplish! CRISIS AVERTED! lol