Recent content by uapak90

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