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

  1. nover11

    Access/ Not sure where to insert Null and parameters

    Hi Duane, Thank you for looking at this and your tips. Not sure what you mean by TGML. Do you mean the formatting of the the SQL, indents and such? I don't understand how to create a form without setting up parameters in a query to test it. Would it be better to add the data to a query then...
  2. 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...
  3. nover11

    Access/ unable to get NZ working in a cross tab

    OH SNAP! It worked great, thank you PH![medal] Thanks again ~Nover11
  4. nover11

    Access/ unable to get NZ working in a cross tab

    Son of a biscuit, i posted the wrong sql. sorry about that [nosmiley] TRANSFORM Sum(Val(Nz([Subject],0))) AS Out SELECT tblOutOfOffice.Assigned FROM tblOutOfOffice GROUP BY tblOutOfOffice.Assigned PIVOT tblOutOfOffice.Date; Thank you
  5. 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