DLookup Help?

[pbaldy]

Sure you can.

 

[gmatriix]

Please if not correct...please correct and send back so I can see what I did wrong.......:banghead:

 

[pbaldy]

Looks like the same file. I'm tired, so here. Your data type was wrong in the target table by the way.

 

[gmatriix]

Thanks for your patients....

I see what I did wrong.... I sent the wrong file...sorry. I think it is something wrong with my db...

It works fine on the one you sent....but when I copy everything exactly it still returns 0.....so I'm not sure what's going on.....I even imported everything over from your db you sent back and its is still doing the same thing.......so who knows....

maybe it some type of setting that is not checked or somthing.....

Thanks anyway.....this is a nightmare:banghead:

 

[pbaldy]

Did you change the data type in the target table? It is Number/Long Integer in the db you sent me, so the fractional amounts round down to 0.

 

[gmatriix]

Here what I think is the problem.

The data is linked to SQL.....so the data types is not set right and it is rounding it to 0.....

I have to find the data type that will let this happen.... I tried it on decimal and it still rounded it to 0...

Do you know what data type in SQL that would allow this?

 

[pbaldy]

Try Money.

 

[gmatriix]

Wooooooooow!

Entirely toooooo much time spent on this one...

Thank you so much for being so patient!!!!!

I tried money and it was almost there....then I tried float and it worked....

This is crazy!!!

Thanks again

Take Care.......you deserve a beer!

 

[pbaldy]

Glad you got it sorted out.