Combining multiple records into one report....help!! 1

[drrep]

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?

 

[LittleSmudge]

Sorry OM - I got lost after the first Dinosaur - says something about my brain at the end of a long day maybe.

Post us a table schema like :-

tblName
PrimeKeyId
FieldName1
FieldName2
etc .. ..


And a similar field list of what you want to produce

And then maybe I'll be able to get my head round it.