exporting

[Bobby L]

When I try to export one of my reports into excel, it's take the leading
zero's out of one of the columns that I'm trying to export. The report is
taking data from a query. The column in the query looks like this: vender ID:
"0000012547".
This number auto fills that column with that number. Is there a way to
export the report into excel without it taking out the zero's. Let me know.
Thanks

 

[RonaldoOneNil]

Not tested this, but try outputting your vendor ID column with an apostrophe
before it.
VendID: "'" & [vendor ID]

 

[Bobby L]

This didn't work. Any other suggestions.

Not tested this, but try outputting your vendor ID column with an apostrophe
before it.
VendID: "'" & [vendor ID]

When I try to export one of my reports into excel, it's take the leading
zero's out of one of the columns that I'm trying to export. The report is
taking data from a query. The column in the query looks like this: vender ID:
"0000012547".
This number auto fills that column with that number. Is there a way to
export the report into excel without it taking out the zero's. Let me know.
Thanks

 

[John Spencer]

What type of field is Vendor ID?

You might need to use the format function if Vendor Id is a number field.

VendID :Format([Vendor ID],"0000000000")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

This didn't work. Any other suggestions.

Not tested this, but try outputting your vendor ID column with an apostrophe
before it.
VendID: "'" & [vendor ID]

When I try to export one of my reports into excel, it's take the leading
zero's out of one of the columns that I'm trying to export. The report is
taking data from a query. The column in the query looks like this: vender ID:
"0000012547".
This number auto fills that column with that number. Is there a way to
export the report into excel without it taking out the zero's. Let me know.
Thanks

 

[Bobby L]

This also didn't work. Any other suggestions. In my query, this data is not
being pulled ffom the table. This is how the column looks like in the query:
expr1: vendor ID:"0000012547". When I export the query into Excel, it works
fine. It's only when I export the report that is feeding from this query that
it takes out the zero's when it goes into Excel.
Hope this helps and thanks for the help.

What type of field is Vendor ID?

You might need to use the format function if Vendor Id is a number field.

VendID :Format([Vendor ID],"0000000000")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

This didn't work. Any other suggestions.

Not tested this, but try outputting your vendor ID column with an apostrophe
before it.
VendID: "'" & [vendor ID]

:

When I try to export one of my reports into excel, it's take the leading
zero's out of one of the columns that I'm trying to export. The report is
taking data from a query. The column in the query looks like this: vender ID:
"0000012547".
This number auto fills that column with that number. Is there a way to
export the report into excel without it taking out the zero's. Let me know.
Thanks

 

[John Spencer]

So what is the data source of the report? Does the data source of the
report have the Vendor Id as described or is the format being applied by
the control that has Vendor ID as the control source?

If the latter, the actual data might be 12457 and the export to Excel is
sending the actual value and not the formatted value.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

This also didn't work. Any other suggestions. In my query, this data is not
being pulled ffom the table. This is how the column looks like in the query:
expr1: vendor ID:"0000012547". When I export the query into Excel, it works
fine. It's only when I export the report that is feeding from this query that
it takes out the zero's when it goes into Excel.
Hope this helps and thanks for the help.

What type of field is Vendor ID?

You might need to use the format function if Vendor Id is a number field.

VendID :Format([Vendor ID],"0000000000")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

This didn't work. Any other suggestions.

:

Not tested this, but try outputting your vendor ID column with an apostrophe
before it.
VendID: "'" & [vendor ID]

:

When I try to export one of my reports into excel, it's take the leading
zero's out of one of the columns that I'm trying to export. The report is
taking data from a query. The column in the query looks like this: vender ID:
"0000012547".
This number auto fills that column with that number. Is there a way to
export the report into excel without it taking out the zero's. Let me know.
Thanks

 

[Bobby L]

I tried formatting the query and the control source on the report
(format"0000012457","000000000").

So what is the data source of the report? Does the data source of the
report have the Vendor Id as described or is the format being applied by
the control that has Vendor ID as the control source?

If the latter, the actual data might be 12457 and the export to Excel is
sending the actual value and not the formatted value.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

This also didn't work. Any other suggestions. In my query, this data is not
being pulled ffom the table. This is how the column looks like in the query:
expr1: vendor ID:"0000012547". When I export the query into Excel, it works
fine. It's only when I export the report that is feeding from this query that
it takes out the zero's when it goes into Excel.
Hope this helps and thanks for the help.

What type of field is Vendor ID?

You might need to use the format function if Vendor Id is a number field.

VendID :Format([Vendor ID],"0000000000")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Bobby L wrote:
This didn't work. Any other suggestions.

:

Not tested this, but try outputting your vendor ID column with an apostrophe
before it.
VendID: "'" & [vendor ID]

:

When I try to export one of my reports into excel, it's take the leading
zero's out of one of the columns that I'm trying to export. The report is
taking data from a query. The column in the query looks like this: vender ID:
"0000012547".
This number auto fills that column with that number. Is there a way to
export the report into excel without it taking out the zero's. Let me know.
Thanks

 

[John Spencer]

The VBA statement would be
FORMAT(12457,"000000000")

or
Format([FieldName],"000000000")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

I tried formatting the query and the control source on the report
(format"0000012457","000000000").

So what is the data source of the report? Does the data source of the
report have the Vendor Id as described or is the format being applied by
the control that has Vendor ID as the control source?

If the latter, the actual data might be 12457 and the export to Excel is
sending the actual value and not the formatted value.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

This also didn't work. Any other suggestions. In my query, this data is not
being pulled ffom the table. This is how the column looks like in the query:
expr1: vendor ID:"0000012547". When I export the query into Excel, it works
fine. It's only when I export the report that is feeding from this query that
it takes out the zero's when it goes into Excel.
Hope this helps and thanks for the help.

:

What type of field is Vendor ID?

You might need to use the format function if Vendor Id is a number field.

VendID :Format([Vendor ID],"0000000000")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Bobby L wrote:
This didn't work. Any other suggestions.

:

Not tested this, but try outputting your vendor ID column with an apostrophe
before it.
VendID: "'" & [vendor ID]

:

When I try to export one of my reports into excel, it's take the leading
zero's out of one of the columns that I'm trying to export. The report is
taking data from a query. The column in the query looks like this: vender ID:
"0000012547".
This number auto fills that column with that number. Is there a way to
export the report into excel without it taking out the zero's. Let me know.
Thanks

 

[Bobby L]

It still takes out the zero's when I export it to Excel. This number
(0000012457) is the same number in that column in the report. Does the number
have to be entered in the table for this to work. Currently it's just an
expression.

The VBA statement would be
FORMAT(12457,"000000000")

or
Format([FieldName],"000000000")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

I tried formatting the query and the control source on the report
(format"0000012457","000000000").

So what is the data source of the report? Does the data source of the
report have the Vendor Id as described or is the format being applied by
the control that has Vendor ID as the control source?

If the latter, the actual data might be 12457 and the export to Excel is
sending the actual value and not the formatted value.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Bobby L wrote:
This also didn't work. Any other suggestions. In my query, this data is not
being pulled ffom the table. This is how the column looks like in the query:
expr1: vendor ID:"0000012547". When I export the query into Excel, it works
fine. It's only when I export the report that is feeding from this query that
it takes out the zero's when it goes into Excel.
Hope this helps and thanks for the help.

:

What type of field is Vendor ID?

You might need to use the format function if Vendor Id is a number field.

VendID :Format([Vendor ID],"0000000000")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Bobby L wrote:
This didn't work. Any other suggestions.

:

Not tested this, but try outputting your vendor ID column with an apostrophe
before it.
VendID: "'" & [vendor ID]

:

When I try to export one of my reports into excel, it's take the leading
zero's out of one of the columns that I'm trying to export. The report is
taking data from a query. The column in the query looks like this: vender ID:
"0000012547".
This number auto fills that column with that number. Is there a way to
export the report into excel without it taking out the zero's. Let me know.
Thanks

 

[Bobby L]

It still takes out the zero's when I export it to Excel. This number
(0000012457) is the same number through out that column in the report. Does the number
have to be entered in the table for this to work. Currently it's just an
expression.

The VBA statement would be
FORMAT(12457,"000000000")

or
Format([FieldName],"000000000")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

I tried formatting the query and the control source on the report
(format"0000012457","000000000").

:

So what is the data source of the report? Does the data source of the
report have the Vendor Id as described or is the format being applied by
the control that has Vendor ID as the control source?

If the latter, the actual data might be 12457 and the export to Excel is
sending the actual value and not the formatted value.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Bobby L wrote:
This also didn't work. Any other suggestions. In my query, this data is not
being pulled ffom the table. This is how the column looks like in the query:
expr1: vendor ID:"0000012547". When I export the query into Excel, it works
fine. It's only when I export the report that is feeding from this query that
it takes out the zero's when it goes into Excel.
Hope this helps and thanks for the help.

:

What type of field is Vendor ID?

You might need to use the format function if Vendor Id is a number field.

VendID :Format([Vendor ID],"0000000000")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Bobby L wrote:
This didn't work. Any other suggestions.

:

Not tested this, but try outputting your vendor ID column with an apostrophe
before it.
VendID: "'" & [vendor ID]

:

When I try to export one of my reports into excel, it's take the leading
zero's out of one of the columns that I'm trying to export. The report is
taking data from a query. The column in the query looks like this: vender ID:
"0000012547".
This number auto fills that column with that number. Is there a way to
export the report into excel without it taking out the zero's. Let me know.
Thanks