Exporting Yes/No field to XLS

I have a membership database which records various options per member
by the use of a Yes/No box.

When I attempt to export a report, including a Yes/No field in XLS
format the Yes/No field is ignored. It does not feature in the report
at all.

Is it possible to inlude a Yes/No field in an XLS export?

Thanks,

Robin Chapple

You're wanting to export the value of a Yes/No field to an EXCEL
spreadsheet? Such fields will export with value of 0 (if the field has a No
value in it) or -1 (if the field has a Yes value in it). Are you not seeing
this result?

--

Ken Snell
MS ACCESS MVP

"Robin Chapple" wrote in message
...
I have a membership database which records various options per member
by the use of a Yes/No box.

When I attempt to export a report, including a Yes/No field in XLS
format the Yes/No field is ignored. It does not feature in the report
at all.

Is it possible to inlude a Yes/No field in an XLS export?

Thanks,

Robin Chapple

No the field is ignored.

I get the previous field and the subsequent field only.


On Sun, 17 Oct 2004 00:52:43 -0400, "Ken Snell [MVP]"
wrote:

You're wanting to export the value of a Yes/No field to an EXCEL
spreadsheet? Such fields will export with value of 0 (if the field has a No
value in it) or -1 (if the field has a Yes value in it). Are you not seeing
this result?

hi,
I think there is something wrong with your export. i
export yes/no fields from access to excel weekly if not
daily.
Regards
Frank

-----Original Message-----
I have a membership database which records various
options per member
by the use of a Yes/No box.

When I attempt to export a report, including a Yes/No
field in XLS
format the Yes/No field is ignored. It does not feature
in the report
at all.

Is it possible to inlude a Yes/No field in an XLS export?

Thanks,

Robin Chapple


.

hi,
I think there is something wrong with your export. i
export yes/no fields from access to excel weekly if not
daily.
Regards
Frank

-----Original Message-----
I have a membership database which records various
options per member
by the use of a Yes/No box.

When I attempt to export a report, including a Yes/No
field in XLS
format the Yes/No field is ignored. It does not feature
in the report
at all.

Is it possible to inlude a Yes/No field in an XLS export?

Thanks,

Robin Chapple


.

On Mon, 18 Oct 2004 19:01:06 +1000, Robin Chapple
wrote:

No the field is ignored.

I get the previous field and the subsequent field only.

Try binding the field to a Textbox on the report that you're exporting
(rather than a Checkbox); format it either -1/0 or Yes/No depending on
how you want the field to appear in Excel. Does this resolve the
issue?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

On Mon, 18 Oct 2004 19:01:06 +1000, Robin Chapple
wrote:

No the field is ignored.

I get the previous field and the subsequent field only.

Try binding the field to a Textbox on the report that you're exporting
(rather than a Checkbox); format it either -1/0 or Yes/No depending on
how you want the field to appear in Excel. Does this resolve the
issue?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

Robin -

I've confirmed in a test what you're seeing, assuming that you're using File
| Export while in the report's Preview mode... am checking now to see if
there's any workaround other than just exporting the report's RecordSource
query (which does work).

--

Ken Snell
MS ACCESS MVP

"Robin Chapple" wrote in message
...
No the field is ignored.

I get the previous field and the subsequent field only.


On Sun, 17 Oct 2004 00:52:43 -0400, "Ken Snell [MVP]"
wrote:

You're wanting to export the value of a Yes/No field to an EXCEL
spreadsheet? Such fields will export with value of 0 (if the field has a
No
value in it) or -1 (if the field has a Yes value in it). Are you not
seeing
this result?

Robin -

I've confirmed in a test what you're seeing, assuming that you're using File
| Export while in the report's Preview mode... am checking now to see if
there's any workaround other than just exporting the report's RecordSource
query (which does work).

--

Ken Snell
MS ACCESS MVP

"Robin Chapple" wrote in message
...
No the field is ignored.

I get the previous field and the subsequent field only.


On Sun, 17 Oct 2004 00:52:43 -0400, "Ken Snell [MVP]"
wrote:

You're wanting to export the value of a Yes/No field to an EXCEL
spreadsheet? Such fields will export with value of 0 (if the field has a
No
value in it) or -1 (if the field has a Yes value in it). Are you not
seeing
this result?

Robin -

The only workaround would involve exporting the report's recordsource by
clicking a command button on a form; or by having the report's Close event
do the export via VBA code (would be exported when you close the report).
There does not appear to be a way to make these fields export from the
preview mode.

--

Ken Snell
MS ACCESS MVP

"Ken Snell [MVP]" wrote in message
...
Robin -

I've confirmed in a test what you're seeing, assuming that you're using
File
| Export while in the report's Preview mode... am checking now to see if
there's any workaround other than just exporting the report's RecordSource
query (which does work).

--

Ken Snell
MS ACCESS MVP

"Robin Chapple" wrote in message
...
No the field is ignored.

I get the previous field and the subsequent field only.


On Sun, 17 Oct 2004 00:52:43 -0400, "Ken Snell [MVP]"
wrote:

You're wanting to export the value of a Yes/No field to an EXCEL
spreadsheet? Such fields will export with value of 0 (if the field has
a
No
value in it) or -1 (if the field has a Yes value in it). Are you not
seeing
this result?