Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: uapak90
  • Order by date
  1. uapak90

    Show date on report

    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?
  2. uapak90

    the expression is typed incorrectly or the query is too complex

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

    the expression is typed incorrectly or the query is too complex

    anyone .. help.. please!
  4. uapak90

    the expression is typed incorrectly or the query is too complex

    the first code works perfectly, the second one doesnt
  5. uapak90

    the expression is typed incorrectly or the query is too complex

    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]...
  6. uapak90

    help with the count function

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

    help with the count function

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

    help with the count function

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

    Expression too complex

    thanks so much helped a lot and will keep helping!
  10. uapak90

    Expression too complex

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

    Not showing up when I try to do By date

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

    Not showing up when I try to do By date

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

    Not showing up when I try to do By date

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

    Not showing up when I try to do By date

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

    Not showing up when I try to do By date

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

    one field to control the other

    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"...
  17. uapak90

    Sum Column with IF

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

    Sum Column with IF

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

    anyway to automaticaly highlight records in a report if value is true?

    thanks alot! thats exactly wat i was looking for.
  20. uapak90

    anyway to automaticaly highlight records in a report if value is true?

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

Part and Inventory Search

Back
Top