Prev: Years of Service Calculation to 2 decimal places
Next: ciao riccardo
From: Debbie B on 15 Mar 2010 11:40
Hi,

I have a linked cvs file that when I do a sum in access I get a different
answer than when I open the csv file and so a sum on the column. Can anyone
explain why this is happening.
From: Jerry Whittle on 15 Mar 2010 11:56
Please show us the SQL statement that you are using to get the sum. Open the
query in design view. Next go to View, SQL View and copy and past it here. If
you are doing something else to get the sum, please tell us.

Are you opening the csv file with Excle or some other method?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Debbie B" wrote:

> Hi,
>
> I have a linked cvs file that when I do a sum in access I get a different
> answer than when I open the csv file and so a sum on the column. Can anyone
> explain why this is happening.
From: Jeff Boyce on 15 Mar 2010 13:23
In addition to Jerry's comments, "different answer" doesn't provide much in
the way of a clue.

Are the two values off by 100th's, or by 100's?

Are these "decimal" numbers, "percents", integers, or ?

Have you confirmed that every row in the csv is actually making into the
rows you see in the linked table in Access?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Debbie B" <DebbieB(a)discussions.microsoft.com> wrote in message
news:86129BDD-0DFE-4B75-AFCA-33B03F966A67(a)microsoft.com...
> Hi,
>
> I have a linked cvs file that when I do a sum in access I get a different
> answer than when I open the csv file and so a sum on the column. Can
> anyone
> explain why this is happening.


 | 
Pages: 1
Prev: Years of Service Calculation to 2 decimal places
Next: ciao riccardo