Getting Null where I shouldn't

[Xenocide]

Hi

I'm doing this

Total1 = DLookup("MontantActuel", "Table850", "IdEngagementA='" & lst1.Value & "' ")

Total2 = DLookup("Sum(MontantActuel)", "Table850", "Maitre='" & lst1.Value & "' AND IdEngagementA <> '" & lst1.Value & "' ")

The first line (Total1) return a Null (which is causing me trouble) but in the table there's something under MontantActuel.

The second line (Total2) is returning me some value. Which is what I don,t understand. It's normal that Total2 return me value.. but why then Total1 don't?

The text field in which I enter those data to be first registred in the database are on the money format and so is those record in the database

somebody can help me?

 

[PHV]

The criteria on IdEngagementA is different for Total2 and Total1.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244