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 gkittelson 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: *

  • Users: yimi
  • Order by date
  1. yimi

    Currency in Query Not Formatted

    OK, Here's what I did. CurrentSumOfPaymentAmount: Format([SumOfPaymentAmount],'$') & IIf(IsNull([SumOfPaymentAmount]),"0 ",[SumOfPaymentAmount]) It seems to be working but it looks pretty crazy to me. Thanks
  2. yimi

    Currency in Query Not Formatted

    I have a query that uses two Query's. In one of my fields I have CurrentSumOfPaymentAmount: IIf(IsNull([SumOfPaymentAmount]),"0 ",[SumOfPaymentAmount]) to return a zero if null. The problem is I need it to return currency. (The data that is correctly formatted in one query even...
  3. yimi

    DON'T WANT TABLE TO UPDATE WHEN CHANGING FORM FIELD

    Sorry for the late response. Hope your still around Jeff (or anyone?!?!) OK here's what I did. I inserted an extra field that is not bound and is input capable for price. I have left the price field in (from the products table) and locked it so that it can not be changed. I've renamed it...
  4. yimi

    DON'T WANT TABLE TO UPDATE WHEN CHANGING FORM FIELD

    Hi, This cannot be that difficult. What am I doing wrong?!?!? I have an order subform that contains product details. IE product name, cost,etc. I have a drop down on the subform so that the product can be selected and the price of the product populates. All fine and dandy. The problem is I...
  5. yimi

    DON'T WANT TABLE TO UPDATE WHEN CHANGING FORM FIELD

    Hi, This cannot be that difficult. What am I doing wrong?!?!? I have an order subform that contains product details. IE product name, cost,etc. I have a drop down on the subform so that the product can be selected and the price of the product populates. All fine and dandy. The problem is I...
  6. yimi

    1 table - 2 combo box. Want column 2 from 1st combo

    I have a table CG Information. In this table I have a field CGCity which uses a combo box to select the field City from another table. (the region field is also part of the combo box but has a width of 0" so its not shown. It's column2) The table the combo box is using is called Region and...

Part and Inventory Search

Back
Top