If Then Statements maybe?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
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?
 
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
 
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
 
Back
Top