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
  • Content: Threads
  • 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

    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]...
  3. 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...
  4. 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...
  5. 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...
  6. 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"...
  7. 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...
  8. 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...
  9. uapak90

    query criterias

    this is probably a simple question, but I really don't know access that well. I have a query which has employee names, employee id, and a couple more fields. When i want to run a query, i want the query to ask me whose name to pull up so i can enter a name and it will show me everythign about...
  10. uapak90

    Updating the Database

    This is for my job, I am not an expert in database but here is my problem: I have a main table that has the name, number and version of training documents. I have to link that to different employees, the only problem is that every employee has different documents they needed to be trained on and...

Part and Inventory Search

Back
Top