My Yes/No field shows up as -1 and 0 on my report.

[Guest]

This is an Access 2000 question from an end user. ;-)

I have a table with yes/no fields with display format set to text box. When
I display the table in datasheet mode, "yes" and "no" show up. However,
when I try to do a chart from the table, I get -1 and 0.

Am I missing something? Thanks!

 

[Duane Hookom]

Your chart has a Row Source. This query should use an expression like:
SomeTitle: IIf( [YesNoField], "Yes", "No")

 

[Guest]

The chart's Row Source has this: SELECT [Better Understanding of
issues],Count(*) AS [Count] FROM [Evaluation Tabulations] GROUP BY [Better
Understanding of issues];

Where do I put your expression?

Your chart has a Row Source. This query should use an expression like:
SomeTitle: IIf( [YesNoField], "Yes", "No")

--
Duane Hookom
MS Access MVP

This is an Access 2000 question from an end user. ;-)

I have a table with yes/no fields with display format set to text box.
When
I display the table in datasheet mode, "yes" and "no" show up. However,
when I try to do a chart from the table, I get -1 and 0.

Am I missing something? Thanks!

 

[Duane Hookom]

Try:
SELECT IIf([Better Understanding of issues],"Yes","No") as Understanding ,
Count(*) AS [Count]
FROM [Evaluation Tabulations]
GROUP BY IIf([Better Understanding of issues],"Yes","No");

You are storing data in a field name rather than as a value in a field. You
might want to take a look at the normalized solutions "At Your Survey" and
"Employee Evaluation" found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.


--
Duane Hookom
MS Access MVP

The chart's Row Source has this: SELECT [Better Understanding of
issues],Count(*) AS [Count] FROM [Evaluation Tabulations] GROUP BY
[Better
Understanding of issues];

Where do I put your expression?

Your chart has a Row Source. This query should use an expression like:
SomeTitle: IIf( [YesNoField], "Yes", "No")

--
Duane Hookom
MS Access MVP

This is an Access 2000 question from an end user. ;-)

I have a table with yes/no fields with display format set to text box.
When
I display the table in datasheet mode, "yes" and "no" show up.
However,
when I try to do a chart from the table, I get -1 and 0.

Am I missing something? Thanks!

 

[Guest]

Perfect! Thank you so much .. and I will definitely check out the survey
site you gave me.

Try:
SELECT IIf([Better Understanding of issues],"Yes","No") as Understanding ,
Count(*) AS [Count]
FROM [Evaluation Tabulations]
GROUP BY IIf([Better Understanding of issues],"Yes","No");

You are storing data in a field name rather than as a value in a field. You
might want to take a look at the normalized solutions "At Your Survey" and
"Employee Evaluation" found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.


--
Duane Hookom
MS Access MVP

The chart's Row Source has this: SELECT [Better Understanding of
issues],Count(*) AS [Count] FROM [Evaluation Tabulations] GROUP BY
[Better
Understanding of issues];

Where do I put your expression?

Your chart has a Row Source. This query should use an expression like:
SomeTitle: IIf( [YesNoField], "Yes", "No")

--
Duane Hookom
MS Access MVP


This is an Access 2000 question from an end user. ;-)

I have a table with yes/no fields with display format set to text box.
When
I display the table in datasheet mode, "yes" and "no" show up.
However,
when I try to do a chart from the table, I get -1 and 0.

Am I missing something? Thanks!