Hi,
I'm sure there is a very simple solution to this, I just can't see it!
I've got a sql procedure that appends records between 2 dates from 1 table to another - there are 2 parameters @datefrom and @dateto, both have the date datatype
I'm using an access front end and have 2 text boxes (datefrom and dateto) to enter the dates on a form which I then need to send to the SQL procedure but no matter what I try I can't get it to work - this the the code I'm using to execute the procedure
Use database
exec schema.nonsk_appendtrial3 @datefrom=datefrom, @dateto=dateto
Any help would be much appreaciated!
I'm sure there is a very simple solution to this, I just can't see it!
I've got a sql procedure that appends records between 2 dates from 1 table to another - there are 2 parameters @datefrom and @dateto, both have the date datatype
I'm using an access front end and have 2 text boxes (datefrom and dateto) to enter the dates on a form which I then need to send to the SQL procedure but no matter what I try I can't get it to work - this the the code I'm using to execute the procedure
Use database
exec schema.nonsk_appendtrial3 @datefrom=datefrom, @dateto=dateto
Any help would be much appreaciated!