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

    Can I set a default value for a parameter query?

    My Bad, This statement actually works just fine if I include the correct operators. Nz([Start Date],"1/1/2002") should be >=Nz([Start Date],"1/1/2002") Maintenance Planner in a Steel Mill
  2. Absalom

    Can I set a default value for a parameter query?

    Thanks dhookum, The usage of Nz that you recommened works just fine for text but I couldn't get it to work for the date/time datatype. I tried each of the following. While I don't get an error, none of them returns any hits from the database. Nz([Start Date],#1/1/2002#) Nz([Start...
  3. Absalom

    Can I set a default value for a parameter query?

    Is there any way I can set a default value for the parameter part of a parameter query. If there was, then when a user left a parameter box empty there would still be the default value to fall back on. Maintenance Planner in a Steel Mill
  4. Absalom

    Asking for Date Parameters twice

    Maybe this will help dawnD3. Open the query that you have based your report on. Open the 'Show Table' dialog (Query/Show Table). Click on the 'Queries' tab and add to your query, a copy of the parameter query you want to use. Insert an appropriate link from the parameter query to one of your...

Part and Inventory Search

Back
Top