I am using Access 2003 to create an Access application using Access as the front end with VBA code and SQL
Server as the back end database.
If you were to add records to a new table titled tblDtlDateRanges with just 2 fields titled
1) RngID (this is an Identity field)
2) DateRange
with the following values:
RngID DateRange
---------- --------------------------
----------
----------
1 LESS THAN 6 MONTHS OLD
2 06 MONTHS TO 12 MONTHS OLD
3 12 MONTHS TO 24 MONTHS OLD
4 24 MONTHS TO 36 MONTHS OLD
5 GREATER THAN 36 MONTHS OLD
How would you create a SQL statement assigned to the variable string strSQL to do load these values into the new table named tblDtlDateRanges ?
strSQL = "???"
Start Free Trial
