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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Create Table Query Question
This worked for me> Sub Populate_Product() Dim conn As ADODB.Connection On Error GoTo ErrorHandler Set conn = CurrentProject.Connection conn.Execute "UPDATE Final_Table SET Product = 'Shell' WHERE Product Is Null;" Application.RefreshDatabaseWindow ExitHere...- Legacy123
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Create Table Query Question
The result is the same. It takes out the rows that had an empty "Product" field. I tried "" also, as in IIf([Merged_Pricelist_with_Inventory]![Product]="","Shell",[Merged_Pricelist_with_Inventory]![Product]) , that does the same thing. Am I better of using ADO and SQL Update statments in VBA...- Legacy123
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Create Table Query Question
This is giving me a pain. I have a source table with a text field that some values are empty. In my create table query, I want to populate the empty fields with "Shell" when ran. I am playing with this design view criteria...- Legacy123
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
