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?

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

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

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

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

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

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

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

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