Problem when Report is Exported to Excel

[manoj9849967222]

Hi All

I need a urgent help. I have a report in which one of the cloumn is "Productid"

My report looks like this

Productid Qty

1.3.2------------------------500
1.4.5-----------------------600

Now when i export the report to excel the productid column gets automatically converted to number.

Could any one tell me what is the problem.


Regards
Manoj

[nico5038]

Excel will assume that the field is numeric.
You can use in your query a concatenation with a space to prevent this like:

select " " & ID,

Nic;o)

[manoj9849967222]

Hi Nico

I have used the SQl given by you. But now it asks for the parameter asking me to enter the product id. I have 100 of productid & i want them all in a single report.

Can this be avoided

Regards
Manoj

[nico5038]

The parameter request is because you entered the fieldname incorrect, Access doesn't recognize it as a tablefield, try:

[Productid]

Nic;o)