I have a table [A] that contains currency values (€) in the field [cost_A].

the Form [B] has a field [cost_B] that is filled using a lookup on table [A] , field [cost_A].

Now I have to do a query con Form [B] with numerical condition on field [cost_B] and sum on the field [cost_B] to obtain a float (or a currency).

It does not work, each  field [cost_B]   is fetched as  2894241000000618044 !!!

any hint?

tks,

pippo