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 bkrike 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: tomcmp
  • Content: Threads
  • Order by date
  1. tomcmp

    Tough query problem, at least for me.

    I might be making more of this than it really is but here goes. I have a quote db that accumulates quote information. Since traditionally we get x% of our bids, this tool should provide some useful information. A quote will have a duration, meaning, if we get the deal, how long will we be...
  2. tomcmp

    nz( ) & Formatting as currency.

    Can't seem to figure this out. I'm using the following in a query January Sales:nz([jansales],0) It works great for replacing a null with a zero but I can't seem to do anything with the formatting. I'd like to format as currency. Right now I would get 34568 instead of $34,568 Can somebody...

Part and Inventory Search

Back
Top