我是使用VBA访问数据库的新手。键入查询无疑是一项挑战。我正在尝试获取两个已知ID之间的所有数据。我有3000条记录,我只想提取(例如(ID 256和540之间的数据。有人能给我指正确的方向吗?感谢
With Recordset
Source = "SELECT * FROM RawData WHERE [ID] BETWEEN " & StartofData 'StartofData user input
.Open Source:=Source, ActiveConnection:=Connection
语法为SELECT * FROM [table] WHERE [field] BETWEEN [value1] AND [value2]
。
因此,以下内容应该有效:
Source = "SELECT * FROM RawData WHERE [ID] BETWEEN " & StartofData & " AND " & EndOfData