D
Des King
I have a query which I want to use the grouping functionality of the Access
report to then export to excel, but I have a problem with some (not all) of
the text values.
Despite all my fields being text values, when I use the report functionality
and then use "Analyse with Excel", it changes many of the version numbers of
pieces of software ie 6.2.1 (recorded as a text value in the field) to a
decimalised number (ie 0.25355614), rending the report useless, as I can not
change the data back by changing the colum format. I use the report option
as this allows me to group the software by the server it is installed on
(There are 3000+ rows of information associated with over 200 servers).
When I check the data of the underlying query and the run the report the
data looks OK and keeps the original format - It is only when I send it to
excel that it is a problem.
I have looked at the report design and this looks OK, but I cannot change
the format of the field on the report (The drop down menu for format shows no
values).
Is this just a feature of Access/Excel reports? or is there something I can
do elsewhere to rectify? I don;t won't to be manually cutting and copying the
data from the very original source like I had to do as a last resort to
ensure the correct format of data.
Any assistance would be greatly appreciated.
report to then export to excel, but I have a problem with some (not all) of
the text values.
Despite all my fields being text values, when I use the report functionality
and then use "Analyse with Excel", it changes many of the version numbers of
pieces of software ie 6.2.1 (recorded as a text value in the field) to a
decimalised number (ie 0.25355614), rending the report useless, as I can not
change the data back by changing the colum format. I use the report option
as this allows me to group the software by the server it is installed on
(There are 3000+ rows of information associated with over 200 servers).
When I check the data of the underlying query and the run the report the
data looks OK and keeps the original format - It is only when I send it to
excel that it is a problem.
I have looked at the report design and this looks OK, but I cannot change
the format of the field on the report (The drop down menu for format shows no
values).
Is this just a feature of Access/Excel reports? or is there something I can
do elsewhere to rectify? I don;t won't to be manually cutting and copying the
data from the very original source like I had to do as a last resort to
ensure the correct format of data.
Any assistance would be greatly appreciated.