Search results

Found this link - it might be helpful... http://www.javaworld.com/javaworld/javaqa/2000-09/03-qa-0922-access.html

Try this... Declare variables e.g. declare @TempDate datetime declare @Year int Assign values @TempDate = GETDATE() @Year = year(@TempDate)

Fairly sure you can't do this with a View. Maybe you could create a Stored Procedure that captures parameter data and then executes a View (with parameter).

My company uses an Access project frontend and a SQL Server 2000 backend for one of it's applications. We have just moved from Access 2000 to Access Runtime 2003, and are currently having a problem with some details disappearing from a Client Contact Log. Users edit/add entries to the log...