Hi,
Ok, so here is the situation.
I got a case where I have a table which has employee information along with an employee rating. Each rating is flagged either three ways with the use of a seperate field in the table: dinosaur, previous and current.
The rating field is of type text.
I want to build a query(ies) that will take all ratings, and put them in seperate text boxes (one for dinosaur, one for previous and one for current) in a report according to each flagged value, per employee.
Problem is I don't know how to seperate each flagged rating into seperate query fields in order to assign each to a seperate textbox in my report
Any ideas?
Ok, so here is the situation.
I got a case where I have a table which has employee information along with an employee rating. Each rating is flagged either three ways with the use of a seperate field in the table: dinosaur, previous and current.
The rating field is of type text.
I want to build a query(ies) that will take all ratings, and put them in seperate text boxes (one for dinosaur, one for previous and one for current) in a report according to each flagged value, per employee.
Problem is I don't know how to seperate each flagged rating into seperate query fields in order to assign each to a seperate textbox in my report
Any ideas?
