I've never done reporting in .net. I don't think it's gonna be easy to convert that project to .net if you've never worked with it.

Also access has been created...

SELECT EmployeeID, LastName, FirstName, MiddleInit, CAST(0 AS Decimal(10,4)) AS Salary FROM dbo.Employees

DataBase Command Console

Don't know what really happens in a shrink... I'll let someone else answer this one.

You can't do it that way without a reporting tool like access or crystal report. You'll have to manually open the recordset with a command object and then present...

It's basically a recordset that you can open/manipulate on the server. It's also viewed as an evil by good coders/dbas because it takes much more time to execute things...

Well if you created views then yes. You need to create stored procedures that have parameters to filter the result set.

One other thing you could do is an Access...

I think you didn't read the thing or you just need to have the last word. The plan is created B4 the execution. The plan also has to...

Can you run the debugger and tell us which line give you this error?

select * from tblOrders where orderDate > '2004-12-31' and FREE = '1' AND [Order code] 'ABC'

Actually : Change the ANSI_NULLS to OFF

but I still wouldn't recommend that option... You need to learn to work with the null values.

Select * from TBL_A where (Col_1 = @DateSubmitted OR @DateSubmitted IS NULL AND Col_1 IS NULL)

Anything = null will return null so you'll never get any results unless you set...

BETWEEN '01/03/2005' AND '31/03/2005'

is the same as doing

BETWEEN '01/03/2005' AND '31/03/2005 00:00:00'. That's why you are missing all the records from that day.

BTW your query will run...

I could make this fancy but it's too simple :

http://www.sqlservercentral.com/columnists/awarren/buildadelimitedlistandquerysyscommentstricksofthet.asp

Can you create a link in the home folder that points to the image folder's image?

Can you post the whole script?