Data Problem? (1 Viewer)

[vbjohn]

I am having this problem and I am thinking that I need to convert the data.

Data:
7,300.00
600.50
400.40

What I am getting:
7,300.00600.50400.40

What I need is:
8,300.90

What I am doing is:
[SessPDm] + [InterimPD] + [DistTravelAmount]


I have Access 2000.

Any help would be great.

 

[Mile-O]

You are concatenating...

Val([SessPDm]) + Val([InterimPD]) + Val([DistTravelAmount])


Instead of the Val() function you might prefer to use the proper conversion function.

Try looking up CInt, CLng, CCur, etc to find which ones are the best for your operation.

 

[vbjohn]

Thanks it works!