format headers in crosstab query

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

Hi
I have a crosstab query that counts yes/no field.
In a headers it shows -1 and o.
How can I change it to something more understandable
like "Serviced" and "Not serviced"?

Can someone please help.

Thanks
Barb
 
-----Original Message-----
Hi
I have a crosstab query that counts yes/no field.
In a headers it shows -1 and o.
How can I change it to something more understandable
like "Serviced" and "Not serviced"?

Can someone please help.

Thanks
Barb
.
If you go into the design view of the query and right
Click to expand...
click in the area where the tables are you can set the
names of your column headings where it says column. You
will want to put the following in where it says column.

"Yes";"No"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dcount in a crosstab query 3
Error 3205 - Too Many Crosstab Column Headers (300) 2
Crosstab Query Header Fields (?) 3
crosstab query child table count 5
Crosstab Problem 1
Make-table query with around 2 ml records taking too long 0
crosstab query question. 3
crosstab query 2

Back
Top