Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cwildeman
Starting Member
40 Posts |
 Posted - 2011-01-19 : 07:50:08
|
| Hi,I am converting an access db to SQL Server tables but am keeping the Access form front end. There is a form called frmReports with two text boxes - txtStartDate and txt EndDate. I want to run reports that are buttons on this form where a user plugs in a date range and the query that drives the report has the following parameter. This runs in Access but I get an 'ODBC Call failed' after moving the tables to SQL Server. Without the parameter the query does run. Can someone help? Thanks, Chuck Between [forms]![frmReports].[txtStartDate] And [forms]![frmReports].[txtEndDate]Chuck W |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-01-19 : 08:36:31
|
| Try reformatting the dates to the character format yyyymmdd==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Converting from Access - SQL Server -Between [form