vb6,dataenvironment, excepting textbox input to sql statements

[bandb]

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?

 

[zemp]

Try this,

...WHERE DATE BETWEEN '#" &TEXTDATE1.TEXT &"#' AND "'# & TXTDATE2.TEXT &"#'"


The number signs qualify the value within as a date. It has been a while since I worked with Access and I am not sure whether the single quotes should remain or be removed. You will find out if it works with the single quotes soon enough.

Thanks and Good Luck!

zemp

 

[bandb]

Zemp;
Thanks for your help. Unfortunately '#"&txtdate1.text&"#'
does not work. I even tried '"# & txtdate.text & #"' and
'"& #txtdate.text# &"' and '"#txtdate.text#"' and
'" &txtdate.text& "'
I am at the end of a project and this is my demise.
the SQL statement is in a command section of the dataenvironment. This allows the datareport to show the results of the search.

If anyone has an idea I am open for suggestions.

Thanks
bandb

 

[awelch]

Sounds like you need to pass parameters to the Data Environment. The process and some code are posted in thread 709-472900.

Good Luck.

awelch

 

[slupton1]

Yes, but did you try:

...WHERE DATE BETWEEN #" & TEXTDATE1.TEXT & "# AND #" & TXTDATE2.TEXT & "#"