crosstab query column heading

[inungh]

I have a crosstab query and would like to change column heading.

The data are "YES" ad "NO" in the table.
The PIVOT clause put the "YES" and "NO" on the heading column.

Is it possible to show "Met" for "YES" and "Not Met" for "NO" like
"as" in s select query?

Like

PIVOT MyField in ("YES" as "Met", "NO" as "Not Met")


Your information is great appreciated,

 

[Jerry Whittle]

Not directly. Create a query that changes the Yes and No answers to Met and
Not Met. An IIf could do it.

IIf([TheField] = Yes, "Met", "Not Met")

In the above I'm assuming that TheField is a Yes/No data type. If it's text
where Yes and No are typed out, Put quotation marks around "Yes".

Save the query.

Next create a crosstab query based on the first query.

 

[KARL DEWEY]

Try this for the PIVOT --
PIVOT IIf([YourField]=-1,"Met","Not Met");

--
Build a little, test a little.

Not directly. Create a query that changes the Yes and No answers to Met and
Not Met. An IIf could do it.

IIf([TheField] = Yes, "Met", "Not Met")

In the above I'm assuming that TheField is a Yes/No data type. If it's text
where Yes and No are typed out, Put quotation marks around "Yes".

Save the query.

Next create a crosstab query based on the first query.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I have a crosstab query and would like to change column heading.

The data are "YES" ad "NO" in the table.
The PIVOT clause put the "YES" and "NO" on the heading column.

Is it possible to show "Met" for "YES" and "Not Met" for "NO" like
"as" in s select query?

Like

PIVOT MyField in ("YES" as "Met", "NO" as "Not Met")


Your information is great appreciated,
.