Right, that's what I meant when I said

and provided this link[/url].

You need to remember that...

And the error would be?

Can you post the DDL, DML, and some test data like mentioned in my signature line?

This should get you started. It does not handle if you have multiple starts and stops for a Unit. You can check out this article[/url] for some ideas...

Based on your most recent post, the IsNothing function should be what you need as in VB.NET a database NULL usually produces an "Empty" object which evaluates to NOTHING. ...

Can you post the full table structure and some sample data like suggested in my the articles in my signature? At this point we also do not know what...

I know I've had a discussion with Jeff on at least one thread about when/why you would use an INSTEAD OF trigger, so I thought I'd post it in here....

You aren't showing any dates being stored so how would you get the duration? You need at least at start time stored in order to get a duration.

IF it has the text, NULL, then you would need to do string comparison:

IIF(Fields!CLSDDATE.Value = "NULL", Count(Fields!OPENDATE.Value), 0)

the only thing I did is add quotes (") around the word NULL.

Sounds like you need a dataset that returns the company name with a parameter for user id.

You can use the HOST_NAME() function to retrieve the client name.

If you aren't sure how to create a trigger you can start by reading this article[/url].

It would be easier to answer the question if you posted the DDL for your tables and some sample data as described in the articles in my signature.

Here is a...

First I need to confirm that you are using SQL Server 2005 Compact Edition as that is the forum you have posted in.

I would not recommend doing this...

This is a duplicate post. Please post answers here.

I guess that would depend on the definition of harassment. I've heard people define harassment as including overhearing an off-color joke being told in another office/cube. If that's...

I believe you want to set the tooltip property on the column/textbox.