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 derfloh 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. binain

    How can I find and replace null values in Access?

    The other option, if you want to keep the values as Null in your tables, is to output them as Nz(Fieldname,"Value instead of Null") For example Nz([Gaskets Sold],0) Nz([Age],"no age given")
  2. binain

    How to time duration of a query?

    I am trying to figure out the amount of time some of my queries take to run, and I was hoping to write a function that would simply "run" each query once or a number of times and calculate the average run time. However, the Execute functionality only works on Action queries - I can't...
  3. binain

    Merge data for two tables

    Update query is the way to go - but in order to make the changes in the 1st table, you have to specify which records. So, create a query joining both tables on the unique key [MAILID], and then make it an update query. The query has to contain the fields you want to contain: Table1.address and...
  4. binain

    What Good are Null Values

    I find Null especially useful in checking conditions based on multiple dates, it saves me mucho code. Switch([FirstDatetoCheck],firstString,[SecondDatetoCheck],secondString,True,"There is no date for this event") (hopefully someone will tell me if this is a dangerous programming...

Part and Inventory Search

Back
Top