Search results

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

hmm ok my query is actually a little more complicated than I let on. I'm not sure how to use the count (*) with it. This is for a quality review database I have fields: LetterCorrect, NameCorrect, AddressCorrect etc (there are a lot of fields) with drop downs of Yes, No, NAA, NA I am...

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

Ya know..everytime I post something here.. I have been trying to figure this out for HOURS.. then I post a question.. then walk to my mailbox and the answer HITS ME NEVERMIND!!! I figured it out! DUH SUM(IIF([Fruit]="Apple",1,0)+IIF([Drink]="MTDew",1,0)) - returns 2 /dance

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

gotcha thanks!!

It looks a little bit like this: Opportunities, defects 12, 1 4, 1 totals: 16, 2 The totals row is SUM I want to take the numbers from the totals row to find the rate defects/opportunities or 2/16 or should I just crete a query that gives me total opportunities and defects without using...

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

WHOOPS! Missed the quotes part! Thanks that fixed it perfectly! /dance

Newp that didn't work. When I take out the brackets and save then run the query it asks me for the parameter again. Then when I go back into builder the brackets are around apple again! >.< weird Maybe I need quotes around it?

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

Hi everyone Thanks for the feedback. I knew I was doing it wrong. I finally figured out how to do it within my query. Funny how one day something seems so hard and the next day it is so simple. Sometimes you just need to walk away for a while lol :) Thanks again!

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