Exporting to Excel

[Jim Jones]

I am using a simple query to group and count records
according to the value of one of my variables. I then
export the 'count' column of the outcome to Excel by
copying and pasting. However, I then have difficulty in
manipulating the data in Excel in the normal way - for
example, I can't format the numbers to include a comma
separator and I can't sum the numbers using SUM. What do
I need to do to the data I export from Access to be able
to use Excel as expected?

Any help would be much appreciated.

Jim Jones
Gaborone
Botswana

 

[Ken Snell]

Export the query itself using the File | Export action from database window.
Then you can work with the column that you want. Your method is changing the
data into a text format, most likely, and EXCEL no longer recognizes the
data as numbers.

 

[john]

Jim,
Hello for Washington State, USA
The first thought that comes to my mind would be to check
the Format setting for the cells that you want to change.
try a number setting in the format of the cells
good luck