Analyze with Excel from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bevatron - 24 Apr 2006 14:35 GMT

I have used Access "Tools" to analyze a query with Exel but can't get Exel to
then total a field without reentering all the numbers in the field. If this
makes any sense to anyone, please help me figure out how to make it work.
Thank you.

Reply to this Message

xlbo - 24 Apr 2006 15:29 GMT

Hi,
when Access exports numbers, it often does so as text. To fix this follow:

Enter a 1 into any blank cell
Copy it
Select all your 'numbers' that you wish to convert to true numbers
Edit>Paste Special MULTIPLY & values

et voila

Signature

Rgds, Geoff

"A crash reduces
Your expensive computer
To a simple stone"

> I have used Access "Tools" to analyze a query with Exel but can't get Exel to
> then total a field without reentering all the numbers in the field. If this
> makes any sense to anyone, please help me figure out how to make it work.
> Thank you.

Reply to this Message

Bevatron - 24 Apr 2006 15:50 GMT

et voila!!! You were so correct! I did have to make the 1 a number cell
prior to copying, but it worked. You have saved me much work and
aggrevation. Thank you.

> Hi,
> when Access exports numbers, it often does so as text. To fix this follow:
[quoted text clipped - 10 lines]
> > makes any sense to anyone, please help me figure out how to make it work.
> > Thank you.

Reply to this Message