O
Olivier L
Dear Access Masters,
This is my first post, so it might be a little messy. I hope I'll give
enough info. I am trying to develop an employee assessment system. I managed
to make a form in table view, it works fine but it is less practical than a
crosstab. The form is based on a one-table-based Query with the following
fields:
Appraisal session, date
Appraisee, Text
Appraiser, Text
Criteria, Text
Score, Number
I would like to get the following form:
Criteria1 Criteria2
Employee1 a b
Employee2 c d
The Appraiser would enter "a" as the score value for Employee1 on criteria1.
Apparently, crosstab queries are read only. Is there any other way around it,
or should I go with the initial table view with one row per
Appraisee-Criteria combination?
Thank you very much for your help
Olivier L
This is my first post, so it might be a little messy. I hope I'll give
enough info. I am trying to develop an employee assessment system. I managed
to make a form in table view, it works fine but it is less practical than a
crosstab. The form is based on a one-table-based Query with the following
fields:
Appraisal session, date
Appraisee, Text
Appraiser, Text
Criteria, Text
Score, Number
I would like to get the following form:
Criteria1 Criteria2
Employee1 a b
Employee2 c d
The Appraiser would enter "a" as the score value for Employee1 on criteria1.
Apparently, crosstab queries are read only. Is there any other way around it,
or should I go with the initial table view with one row per
Appraisee-Criteria combination?
Thank you very much for your help
Olivier L