If Then Statements maybe?

Q

QRATRAINER

Ok, I have 2 tables one for training in 04 and one for training in 05. I
want to run a query to give me the latest training date. Say for Fire
Safety....I want to get when the last time susie had training, was it 04 or
05 and to show that date. I thought it would be something like.....retrieve
information before todays date, but if there is a date in 05 do not give me
the date in 04, if there is no date in 05 give me the date for 04. I also
want to run this by home, so I want it to prompt me with the home name but do
the lastest training date. i'm thinking run a query for each training topic?
I hope this wasn't confusing.
 
R

Rick B

You might think about revising your database structure. Creating a new
table every year is normally a very bad idea. If you have the date in
there, then why would you need multiple tables?
 
Q

QRATRAINER

Our training structure is quite odd. We have over 300 employees who train on
25 different topics at different times of the year. It seemed to be easier
to be to enter them in a database when they come in, rather than search thru
and find the last time they has the session and change the date. Maybe I
need a new system?
 
M

mscertified

Yes I think you need a new system.
At first glance it seems you need a minimum of three tables
Employees, Topics, Training
All training should be in one table regardless of date
The Training table will have columns for Employee, Topic and Date
Don't change any dates, just add the new records, that way you keep a
history of training - which could be useful.
Its up to the reporting mechanism to pick out the latest training date -
which is trivial if all records are in one table.

Dorian
 
Q

QRATRAINER

would the report automatically pick the latest date or would I have to use an
expression?

sorry, I'm SO new to access' deeper functions, and the newbie page all
topics seem to get lost
 
J

jahoobob

I don't think Rick was saying change the date for the person, I believe
he means for you to add a new record for each time a person receives
training. If each person goes through 25 classes a year you would have
300 X 25 records for each year in the same table. You then have to
query on the Last date for each person for each class. Very easy.
 
Top