Hi,
I would hardcode the SQL Statements (Select, From, Where, Between) in to
Global variables as such....
Private Const sqlSelect As String = "SELECT b.OrgID, a.OrgName, "
Private Const sqlFrom as String = " FROM tblossevent AS b, tbOrg AS a"
Private Const sqlWhere as String = " WHERE "
Private Const sqlBetween as String = " BETWEEN convert(varchar, _
getdate()-30, 106) AND convert(varchar,getdate(), 106)"
You can then construct your SQL statement fairly easily with the following
syntax:
Let strSQL = sqlSelect & sqlFrom & sqlWhere & YourVariable & sqlBetween
Then you can use strSQL as your SQL string!
Does this help?
Oli
--
Message posted via
http://www.officekb.com