Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TIPtip

    ihave a field in table that is numb

    thank you!
  2. TIPtip

    ihave a field in table that is numb

    In a qwery i dont see .44
  3. TIPtip

    los decimals

    in table a field is Double, format standard and decimal places 2 i have this calculating in qwey
  4. TIPtip

    los decimals

    val(NZ([table].[field],0)) returns zero 0 then i calculate : 0 - 123.44 and returns -123 and i lost 0.44. How to handle this?
  5. TIPtip

    ihave a field in table that is numb

    one more question: val(NZ([table].[field],0)) returns zero 0 then i calculate : 0 - 123.44 and returns -123 and i lost 0.44. How to handle this?
  6. TIPtip

    ihave a field in table that is numb

    thank you very much.
  7. TIPtip

    ihave a field in table that is numb

    ihave a field in table that is number(double). when i calculate some stuff i use function NZ(field,0) and in some cases it return number(right alligned) and in some cases it returns like string (left alligned) do i use right function or where is the problem
  8. TIPtip

    i have table (x) that have primary

    thank you
  9. TIPtip

    i have table (x) that have primary

    i have table (x) that have primary key from two fields(a,b). When i insert values in another table (y) into fields a1 and b1 and i choose from lookup table(x) field(a) from table x i want that automaticaly field b1 is filled with value b from table x. how to do this? Are thre any triggers?

Part and Inventory Search

Back
Top