When pasting from access fields start with a null

[zathrus777]

I created an access query and the results are figures that do not add (i.e. give 0 totals). On analysing the file in a hex editor (desperation) each cell starts with a null which I can get rid of by selecting the cell and deleting left.

Is there an easy way to remove all the null characters?

 

[SkipVought]

Hi,

Have you tried using one of the Numeric Convert functions???

CDbl([Field1])+CDbl([Field2])+...+CDbl([Field[i]n[/i]])

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244