Ben_Entrew
Registered User.
- Local time
- Today, 08:13
- Joined
- Dec 3, 2013
- Messages
- 177
Hi all,
I want to select a subset of table called TRP. It should extract me all records
which got the property Valid to date < enddate.
enddate is a date selected by the user in a form .
Somehow it doesn't recognize the enddate in the following :
Your help is much appreciated.
Thanks in advance.
Regards,
Ben
I want to select a subset of table called TRP. It should extract me all records
which got the property Valid to date < enddate.
enddate is a date selected by the user in a form .
Somehow it doesn't recognize the enddate in the following :
Code:
Public Sub test()
DoCmd.SetWarnings False
DoCmd.RunSQL "SELECT TRP.* INTO [TEST] " & _
" FROM TRP " & _
" Where TRP.[Valid to] < enddate"
DoCmd.SetWarnings True
End Sub
Your help is much appreciated.
Thanks in advance.
Regards,
Ben