Yes CardID is a number feild
SELECT CardInfo.CardID, PassengerInfo.PassengerName, CardInfo.OpeningCardBalance, DSum("TopUpAmount","TopUpInfo","CardID=" & [CardID]) AS TopUpSum, [OpeningCardBalance]+[TopUpSum] AS Credits, DSum("Cost","ChargeQuery","CardID=" & [CardID]) AS Debits
FROM...