I am trying to access fields from an access2k database using vb6, dataenvironment and showing a datareport.
I am trying to use the data from two text boxes in my sql statement to initiate the report.
SELECT DATE, [FIRST NAME], [LAST NAME], COST1, COST2
FROM EXPENSES
WHERE DATE BETWEEN '" &TEXTDATE1.TEXT &"' AND "' & TXTDATE2.TEXT &"'
The ubove where clause is all one line. This does not work.
What would be the correct code to maqke this work?
I am trying to use the data from two text boxes in my sql statement to initiate the report.
SELECT DATE, [FIRST NAME], [LAST NAME], COST1, COST2
FROM EXPENSES
WHERE DATE BETWEEN '" &TEXTDATE1.TEXT &"' AND "' & TXTDATE2.TEXT &"'
The ubove where clause is all one line. This does not work.
What would be the correct code to maqke this work?