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.

ID	Line	CUR	Amount	Amount US (CALCULATION)	FX Rate
1	A	GPD	100	150	1.5
2	A	GPD	100	150	1.5
2	B	GPD	500	0	1.5

<tbody>
</tbody>

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?