Search results

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...

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...

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...

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...

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...

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 ;)

Hi I have many queries I want to run off of a group of data. For each query I'm going to select a UserName, Year, Month, and ResultType. Those 4 things will all be constant for every query. Then I wand to do about 100 different 'views' of the same data. I want a query that counts all Defect...

Hello again! Welcome to my daily head scratcher. I have a query that selects rows based on criteria then does some counting. The selecting and counting is fine as long as the criteria found some rows. but if there are no rows selected instead of zero I get a blank cell. here is an example...

Hello Having trouble <again> I have columns like [Fruit], [Drink] etc I have a query that runs that says for example this: IIF([Fruit]="Apple",1,0)+IIF([Drink]="MTDew",1,0) With other criteria I end up with 4 records that meet all my criteria and there is 1 record where Apple is present and...

Hello Right now I have a table that shows process opportunities and defects by type. Each row is a separate record and I count each process defect as 1 I have another calculation that counts opportunities. Then I use the totals row at the bottom to tell me how many total process defects there...

Hello I have a query that returns results based on customer name and year. In the dataset I have many rows like customerID, ProductType, ProductDescription. After I get my first dataset for customer/year I then want to find all records where ProductDescription = Apple and count that as 1...

Hello I have data stored in a table. For each record there are multiple fields that the data is Yes, NO, NA, FYI. I want another field on each record to count how many of these items are not NA or FYI, but I don't know how to set that field up to automatically count without some kind of user...