Column headings in a query 1

[mendi80]

I am trying to create a query that will track weekly production reports that are submitted by each employee. I would like the query to be displayed as follows:

Date Employee1 Employee2 Employee3
1/1/05 X X X

(The X represents check boxes)
(The employee column headings would be coming from tblEmployee)

I tried to create a cross-tab query, which gave me the exact lay-out I was looking for, however, the data section was displayed as values, not check boxes. Is there anyway around this?

 

[lupins46]

Don't think so.
Crosstabs can only show numbers in in the stats part.

 

[lupins46]

Just messing around with this and found that you can format a crosstab column (in design view) to show Yes or No using the format string :
"";"Yes";"No"

 

[alvechurchdata]

I can't think of a diect solution but here are two alternatives:

One is to create an empty table with the logical fields repersented as check boxes then use a second append query to put the values from the crosstab into this table.

The other is to create a form to display the results of the crosstab.


Geoff Franklin

http://www.alvechurchdata.co.uk

 

[mendi80]

lupins46

Thank you soo much, you have no idea how long I've been working on this. Works perfectly!!