var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Multiple Acces Variables Passed through Sql
I am trying to use multiple variables in my sql statements using Visual Basic ADODC. I cant get it to work. Below is my code. Can anyone please help.
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Senior Project\Timeworks02.mdb;Persist Security Info=False"
.RecordSource = "Select sum(hourstotal) as sumHours from timecard where emp_number = & empnum and weekending = & dateweekending and bill_id = 5 and resource_id=1"
empnum and dateweekending are my variables
Last edited by waihiwa2; 10-10-02 at 19:04.
.RecordSource = "Select sum(hourstotal) as sumHours from timecard where emp_number = " & empnum & " and weekending = " & dateweekending & " and bill_id = 5 and resource_id=1"
That should do...
Thank You very much for the tip!!!