Dwight has attended:
Access VBA course
VBA with SQL
What is the best way to call up SQL Script in VBA??
RE: VBA with SQL
Hi Dwight
The basic code that you need to use is as follows:
[code]
Dim mystrSQL As String
mystrSQL = "Your SQL statement goes here