- Local time
- Yesterday, 21:35
- Joined
- Feb 28, 2001
- Messages
- 27,243
I've got a question to ask that is strictly for completeness but I didn't see it asked in the thread. What is the data type of [House_Number]?
Gina, presuming that moishier correctly reported the output from the Debug.Print, it did not convert the 6 to text because if it had, Debug.Print would have reported > "6"
<>"" And Is Not Null And Like "[0-9]*"
(house_number > " & Val([Forms]![bulk_add_complaints2]![start_number]) & ")
INSERT INTO complaints(unique_account_number, reason_code,missing_from,missing_to,complaint_date,complaint_text) SELECT master_list_filtered.unique_account_number, 'DC','1/25/2019','1/25/2019','1/27/2019 8:36:01 PM','test' FROM master_list_filtered WHERE (house_number >= 3)