How to delete a record with money columns?

[enak]

I have a table that I need to be able to delete some of the records.

Here is my query:

delete * from tblValues where AcctID = 13 and [Date] = #11/4/2005# and NetCashFlow = 297120.74 and MarketValue = 302030.00

The fields, NetCashFlow and MarketValue are currency fields. When I run the query nothing happens. The record is not deleted but I get no errors.

If I open the table the data is formated as money, $297,120.74

How do I delete these records?

Thanks,
enak

 

[Golom]

It's possible that your fields have non-zero values in the third or fourth decimal place but they are not being shown by the format. Try something like

Delete * 
From tblValues 
Where AcctID = 13 
and [Date] = #11/4/2005# 
and Format(NetCashFlow,"0.00") = '297120.74'
and Format(MarketValue,"0.00") = '302030.00'

 

[enak]

Thanks, that worked.