Search results

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

Hi I'm having a brain spasm today! I have 2 tables Table 1: QualityReviewData Has field OpDefCust1 Table 2: OperationalDefinitionsCustomer Has fields Checkpoint and Description Table 1 field OpDefCust1 is joined to table 2 I want to select from QualityReviewData field OpDefCust1 and...

Hello I have a query where I select certain rows based on User, Department, Year and Month. that gives me a list of rows for the specific user I want to look at Then I want to count items within these rows based on what is in the fields. For example...

I flubbed that all up. All better now :) weeeeeeeeee! It works! /dance Happy Friday!

Good morning. I have a report with 1 sub report. When I run the main report it puts the field in for the sub report but there is no data. So the calculations have not run. :eek: How do I get the sub report to run when the main report is launched? TYVM Happy Friday! /dance ;)

hrmmm well that worked with about 10 items but after I added in all of them it said Query is too Complex! maybe i can break it up into a couple queries with some queries in each and try to get the report wizard to link all those into 1 report. I don't think that will work either actually.