Access join /calculation not returning correct value

[JVID720]

Here is my table and my error (Highlited). How come my join is doing this? If there are multiple lines then the calculation doesn't work.

[TABLE="width: 500"]
<tbody>[TR]
[TD]ID
[/TD]
[TD]Line
[/TD]
[TD]CUR
[/TD]
[TD]Amount
[/TD]
[TD]Amount US (CALCULATION)
[/TD]
[TD]FX Rate
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]A
[/TD]
[TD]GPD[/TD]
[TD]100
[/TD]
[TD]150
[/TD]
[TD]1.5
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]A
[/TD]
[TD]GPD
[/TD]
[TD]100
[/TD]
[TD]150[/TD]
[TD]1.5
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]B
[/TD]
[TD]GPD
[/TD]
[TD]500
[/TD]
[TD]0
[/TD]
[TD]1.5
[/TD]
[/TR]
</tbody>[/TABLE]


Thanks

 

[Joe4]

I think we need more detail.

How many tables are involved?
How are they "joined" (you mentioned "join")? Posting the SQL code of your query may help.
What is the formula you are using for your calculation?