Is my sql commands correct

[RhazeMondragon]

"Select F_Empl_Code, Supply_Date, Sum(Supp_Total) , Min(Supp_Balanc e) from Tbl_Supply_Tran saction Where Supply_Date between '" & txtDate1.Text & "' and '" & txtDate2.Text & "' GROUP BY F_Empl_Code, Supply_Date

this is my syntax.. but it cause error,, help me pls.... thanks!!!!!!

[Killer42]

What error do you get?

Perhaps you have the wrong delimiters around your date values, as mentioned in the other thread.

[debasisdas]

Kindly post the exact error message.

I think you need to format the date to the realated database date format.

[9815402440]

Hi.
Use # as delimiter for date values.
Your query should look like:
"Select F_Empl_Code, Supply_Date, Sum(Supp_Total) , Min(Supp_Balanc e) from Tbl_Supply_Tran saction Where Supply_Date between #" & txtDate1.Text & "# and #" & txtDate2.Text & "# GROUP BY F_Empl_Code, Supply_Date"

Regards,
manpreet singh dhillon hoshiarpur