how to make row headings in crosstab query

[rehanemis]

Hi,

I have designed the crosstab query, Just like there is option to add fix column headings (for column heading on property bar), can we set fix row headings? if yes then ca you please explain how?

Thanks and waiting of your answer.

 

[sxschech]

Maybe with IIf statements or joining to another table that has the fixed values to be displayed matched against the field in your other table?

 

[rehanemis]

Thanks, joining the two tables works.

did you know how to high light duplicate value in form or report on single field?

 

[sxschech]

Do you have an example? Is it like this?

Item 1
Item 1
Item 2
Item 3

Or this?

Item 1 Item1 Item2

 

[rehanemis]

Yes, but have different criteria. DB has two columns to check for duplicate.

Column 1 contains time slot like 6:00 Am to 7:00 Am, 7:00 Am to 8:00 Am so on
Column 2 contains department like Dep 1, dep 2 so on

I would like to color the field in red if Same time slot is used twice in a Department.

 

[JHB]

Use the Conditional Formatting, below is a link how to use it with some samples.
https://support.office.com/en-sg/ar...rmatting-6ba9e9fa-4347-4183-b335-44e43b05e22f