Np... have the same problem in Access, when one syntax fails, try another .

Let me rephrase. It's very simple for a diplomed programmer .

Anyways, here's an exemple of an insert/update/delete/select procs that you will need for...

I see. How fast was that monster running anyways??

You need to buy a book for this. I would strongly suggest that you follow a basic sql server course to get you started. You have too much...

They preffer scrolling through 1000s of rows and a few dozen columns to find data instead of doing 2-3 simple clicks and seeing only what they need????

Are you sure you...

Ouch... is it possible to see such a query?? I've never seen one that big .

Tx... it's true that I try to drive the point home, hard, at times .

Have you tried rewriting it as

For each Task in ...

next

??

So true... wasn't that quote from Boston Public or another show?

Wasn't the solution Replicate('[A-Z]', len(@Var))??

It's hard to tell wether or not the design is wrong... But 50 tables views!! for a single query seems like a lot to me.

Is there anyway that you could...

Is it possible that you only have and item with id 0?

What did you find out when running this in debug mode?

Seems very simple. You'd have one or two tables containing the form info. Then you need one proc to insert the new data, one more to update the...

Since when are you repeating yourself Noeld??

[Edited]

Much better .

Let's start from the beginning.

What info are those tables containing and what info do you want the query to show (with sample data for the query)?