Search results for query: *

I have a report linked to a query. The query is set up where the field of date is between two certain dates. So when i open the report, it asks me for the beginning date, and the ending date. Is there any way I can show those dates on the report itself?

You know what happened, before, I had the "alert" and "action" fields as Yes/No, then I changed it to all text, but since I have check boxes, it just displays as either "-1" or "0", for the first query, I changed all the No's to 0, but for the second one, all my fields still had No in them, so...

anyone .. help.. please!

the first code works perfectly, the second one doesnt

It just started happening to my query, I was trying to make another query like this one : SELECT [Personnel (2008)].[Room/Location], (Abs(Sum([Personnel (2008)].[Alert]))) AS [# of Above Alert], (FormatPercent([# of Above Alert]/[Total Personnel Samples])) AS [% of Above Alert]...

I forgot to add that there are two things, Alert is when the count is 2 but less than 3 Action is when the count is 3 or more If I figure out Alert, I can do action, but the code you gave me, was giving me a value like 20, which was the amount of times I entered Compounding in my data...

randy, your code works but it does not give me the results I want, I want to count how many of the samples have 2 or more counts but less than 3. The code you had kind of counts everything, and in the data I have, none of the data was equal to 2, infact everything was 0. And if there is no...

Once again, i am stuck with a function. Let me show a sample of the data then I'll go from there. Date Room/Location ColonyCount 01/02/08 Compounding 0 01/03/08 Ointment 2 01/04/08 Compounding 3 01/05/08 Liquid 0...

thanks so much helped a lot and will keep helping!

I want to run a query, rather an easy one but I'm a beginner at it so I am not sure how to actually condense all this information. I have the following fields that I really care about: Room/Location Schedule Pre Post I have the following Rooms Compounding Ointment Liquid AIrlock Corridor...

I found my error, it was originally in my table. When I put the date field in there, the field name was Date and the data type was text, with the input mask designed for a date. When I changed the data type from text to Date/Time, it worked. Thanks for all your help! I will definitely remember...

If I take the date field out, everything is good, it groups the room by the name and shows me the total samples from the room, but it does that for all the data in there. Thats the reason I wanted to specify from what to what dates I wanted the data to sort through

Well I had to revise your code a little but at the end this is what it looked like: SELECT [RCS (2008)].[Room/Location]...

SELECT [RCS (2008)].[Room/Location], Sum((((((IIf([Room/Location]="Liquid",10,(IIf([Room/Location]="Compounding",11,(IIf([Room/Location]="Ointment",9,(IIf([Room/Location]="Airlock",1,(IIf([Room/Location]="Corridor",2,(IIf([Room/Location]="Gowning (Prod)",1,""))))))))))))))))) AS...

Hey Everyone, Have a slight problem sorting my data through the date: I have a table that have the following field Date Lot# Room/Location Count Pre/Post I want to make a query that if the Room/Location persay says "compounding" ill add a column that will say number of samples and if its...

Hey I am making a table in which I have to record times if a sample was found at a certain time. I have the following fields Date Room/Location NumberOfTimes Chest LeftFinger RightFinger LeftWrist RightWrist LeftForearm RightForearm Right now, the default value in all the body locations is "0"...

thanks for the quick reply the reason i had to multiply by 7 is cuz for every time they would go, they would check 7 samples, so if they went in 3 times, they would have checked 21 samples.. but i think me summing up a query that was related to a field that was multiplying by 7 messed it up. I...

Hey Everyone, I have a slight problem. I am making a database for the Microbiology department for my work, and I have several tables. I want to make a query using these fields: Date Room/Location NumberOfTimes What the field number of times is , the number of times they checked the samples...

thanks alot! thats exactly wat i was looking for.

I am working on an employee training database and i was printing out reports on employees. One of hte fields indicate if their training is complete ont hat document or not. I was wondering, is there anwyay the incomplete records could stand out or liek whenever its incomplete, it highlights...