Please help me!!!

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

Hi to anyone who can help.

I have a table with the following fields:

Last Name
First Name
Course ID 1
Course date req 1
Course ID 2
Course date req 2
Course ID 3
Course date req 3
Course ID 4
Course date req 4
Course ID 5
Course date req 5
Course ID 6
Course date req 6

Each of these date fields stores the date that the
employee requested the course.
Each of the ID fields contains the name of the course.

I am trying to create a crosstab to see which employees
requested which course but I have no idea what I am doing
wrong - the information is just not coming out and I an
not sure which field should be my value field???
Hope this is clear...

Kind regards

Ann
 
Just an observation...

It appears that your table structure is wrong. If I see it correctly, you
have employees and they can request and complete classes. Employee 1 might
requests a particular class (How to build a Widget) for their first course.
Employee 2 might request a different class (How to Sell Widgets) for their
first class.

If my assumption is correct, you should have a table for the employee, a
separate table where the course names and descriptions are stored (if you
want to be able to look them up, and a third table where you would have the
employee number or key, the course, and the date. The third table would
have a variable number of records. If an employee had requested one course,
they would only have one record in table3. If an employee had taken 8
courses, they would have 8 records.

This scenario is a classic one-to-many relationship.

That being said, if my assumptions are correct, and you wissh to normalize
your structure, then your reports and queries would need to be completely
changed.

If my assumption is completely wrong (it has happened once) then let us know
what specific errors you are having with the results of your query and maybe
we can help. How did you build it? What are the results? Etc.

Rick B

Hi to anyone who can help.

I have a table with the following fields:

Last Name
First Name
Course ID 1
Course date req 1
Course ID 2
Course date req 2
Course ID 3
Course date req 3
Course ID 4
Course date req 4
Course ID 5
Course date req 5
Course ID 6
Course date req 6

Each of these date fields stores the date that the
employee requested the course.
Each of the ID fields contains the name of the course.

I am trying to create a crosstab to see which employees
requested which course but I have no idea what I am doing
wrong - the information is just not coming out and I an
not sure which field should be my value field???
Hope this is clear...

Kind regards

Ann
 
Thanks Rick

I think I better think it out again!!

I see to have all the tables so maybe I should include the
related ones and pull the info from there.

Will try this out and get back if I get stuck again.

Many thanks and kind regards from Ireland

Ann
 
Back
Top