Parameters are not compatible with this function

I am trying to do some adding up of a couple of recordset fields like this:

Dim CashAndCheques as Double
CashAndCheques = rs.Field(“Cash”).DoubleValue + rs.Field(“Cheque”).DoubleValue
lbTillTakings.AddRow rs.Field(“TillNo”).StringValue, rs.Field(“Date”), CashAndCheques —> I get an error saying Parameters are not compatible with this function

I also tried just doing
lbTillTakings.AddRow rs.Field(“TillNo”).StringValue, rs.Field(“Date”), rs.Field(“Cash”).DoubleValue + rs.Field(“Cheque”).DoubleValue

But get the same error. Does anyone know why?

I do not, but you may store the values into variabls (so you will be able to wee their contents in the debuger) and use these values with AddRow. Some light may comes from that.

CashAndCheques is meant to be a double and AddRow only accept strings…

Ok thanks. I just tried doing this and worked.
lbTillTakings.AddRow rs.Field(“TillNo”).StringValue, rs.Field(“Date”), Str(rs.Field(“Cash”).DoubleValue + rs.Field(“Cheque”).DoubleValue)

Thanks.