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

    Access/ Not sure where to insert Null and parameters

    Would you be able to help me out with this error? I’m trying to get the tblOutOfOffice (“Subject”) to pull (if subject,subject,0). It’s not doing it when I add in the parameters for that date. It’s only pulling the people out of office and not showing those who should be “0” PARAMETERS [Start...
  2. nover11

    Access/ unable to get NZ working in a cross tab

    I created a crosstab to run days in office. If they take time off it gives a value, if they are in all day it leaves it blank. I would like to return a zero showing that they were in the office that day. I used Sum(Val(Nz([Subject],0))). In the total tab I used expression. Still blanks! May i...

Part and Inventory Search

Back
Top