epyonz Newbie

Joined: 19 Jan 2009 Posts: 4
|
Posted: Tue Jan 27, 2009 5:08 am Post subject: General Database Help |
|
|
I have nearly finished the database I am creating but have a few more problems that i'm still not sure how to solve.
I have 3 tables, applicantinfo, questionaireinfo and traininginfo, with the idea of the database being that first info about the applicant is entered, then a questionaire is sent to be returned with the data from that entered into the questionaireinfo table. Finally they will be invited to training and whether they come or not will be recorded into the traininginfo table
I have a query that calculates the difference between dates and leaves it in the form "x weeks". I have a from that, using listboxes, allows the selection of graduatation date (from the applicantinfo table) and the gender (again from the applicantinfo table). The selections from the form are saved into a seperate table that just contains one field which are the 3 selections.
What i would also like to be able to do is have a weeks listbox added to the form so that this can also be a selection clause. Is there any way to do this.
Thanks epyonz |
|