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. rsmack

    how to get zero for null fields in a query

    alexcuse, how do i do i handle it in the query? yont11, thanks. i do know (now) how to do that. it does require a move for every field.
  2. rsmack

    how to get zero for null fields in a query

    thank you lars7, i can work this out one field at a time, but i have something like 8 fields for each of four quarters, as well as summaries of in and out transactions of multiple field payments for each of 13 customers, so i am looking for a global method to get zeroes into the queries...
  3. rsmack

    how to get zero for null fields in a query

    i use a query to summarize transaction data from several tables for presentation in a form. if a table has no entries, because there are not yet any transactions of that type, the query returns null values for that table. these are unusable for calculations, such as totals. is there some way to...
  4. rsmack

    default to zero

    thanks aceman1, this looks like something i'd have to do for every field. ? is there a way to do this, uh, globally?
  5. rsmack

    default to zero

    i use a query to summarize transaction data from several tables for presentation in a form. if a particular table has no entries, because there are not yet any transactions of that type, the query returns null values for that table. these are unusable for calculations, such as totals. is there...

Part and Inventory Search

Back
Top