Recent content by Vargasman

THANKS! That was exactly what I was looking for.

I should of explained what I need a little better. I have 2 tables one with personnel info and another with attendance info. Each office wants to know who show up for each event weekly. The names are pulled form tblPersonnel and the dates and number of events attested come from tblAttendance...

I am trying to build a report based off of a query for weekly attendance. My query as of now uses the Between [Start Date] and [End Date] for it's criteria. The problem I am having is that everyone will not have an entry every week but I will need everyones name returned in the report. How would...

I need some help with this code. As of now when I have people take a test, the code spits out the missed questions with the correct answers as well ass you score to the file C:\test.htm. It works fine on windows 2000 where we can still write to the C:\ drive but I need it to work on XP too. So i...

Where would you place this formula to calculate the time and enter into the table? the only place i can get it to show up is the control source but then it doesn't get written to the table. Thanks

I know where all the tables and fields are. I am trying to make a trouble ticket/system outage database. I will have an entry every day with daily info and the days ID number. I want to fill in the Day ID number into the outage table automatically based off of the last created day ID Number. So...

I know where all the tables and fields are. I am trying to make a trouble ticket/system outage database. I will have an entry every day with daily info and the days ID number. I want to fill in the Day ID number into the outage table automatically base of the last created day ID Number. So if i...

How would I automatically fill in a field on a form with the data from the last created record from another table? example: TicketInfoForm IDnumber=001 > TicketOutageForm InfoIDnumber=001 TicketInfoForm IDnumber=002 > TicketOutageForm InfoIDnumber=002...

I am tyring to set up a query, that runs from a selected date range, to return only the records that don't meet the requirments. For example, I have four fields: Name Date Attended Required I want to start the query from a date range usesing Between [StartDate] And [EndDate]. There are...

Thanks again for all of your help. I have all my tables set up in a functional manner.

Thanks for your quick relpy...How would you break out each table, collumn wise? At least for the following tables tblTrainingClass tblTrainingClassSession tblSessionBooking

I've been tasked to create an application that can track weekly training sessions for over 300 personnel. I'm not sure how to set up the tables to get the desired results. I will need to be able to pull weekly reports based from date query, including the number of sessions attended and what...

i have a report that opens from a query that pulls from 8 different tables using the date as the primary key for each table. I want to be able to open my query without having to input a blank record for each date in each table. Basically I don't use every table everyday. Sometimes I just use 3-4...

This is what worked for me... Create a form (call it SelectDates) and put 2 unbound text boxes on it. Call them txtStart and txtEnd. Then go to each of your queries and put the following as the criteria for your date fields: BETWEEN Forms![SelectDates]![txtStart] AND...

Thanks again