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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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")- binain
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
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...- binain
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
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...- binain
- Post #2
- Forum: Microsoft: Access Tables and Relationships
-
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...- binain
- Post #3
- Forum: Microsoft: Access Other topics
