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!

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

    Line not showing up in a query

    I have a query that is working, almost. There are a few items in "MOI" table where the value is 0. When I run the query, those items are not showing up. I would like for them to show with a value of 0. I used the design wizard to make the query. I was hoping someone could go through the SQL...
  2. Guinfan

    Problems with NULL in queries

    I've created a querie that sometimes returns a null if there is no relevant data. I think it's a null as there is no info showed, just the "headers" of the columns. Anyway, I need it to show a 0 (zero). Anyone know how I can do this? Thanks

Part and Inventory Search

Back
Top