Hi PG,

Well, what a surprise, a reply on a 3 year old post.

To be honest, I totally forgot about 2sql. No, I never got any replies.

Having said that pretty...

Never mind, I'll post a reply myself:

http://www.mssqltips.com/tipcomments.asp?tip=1489, Comments and Feedback section

Looks like it is not an issue in 2012 (I tested it, 6 columns: works).

Not sure though...

I'm experiencing exactly the same problem.

On a course right now, and on my day of I tried to make it work on my laptop.

Did you get it sorted?

Any one else?

Henk

Guys come on, dont be so naive asking for download.

Did anyone have a look at learndevnow.com?

I did, I got a trial subscription. Wasn't bad, but how shall I say...

Never mind, I think Ive got it figured out, or Im starting to get the hang of it.

In case anybody is interested: I found videos by PCTeachMe on Youtube.

There...

Thanks for your replies.

I had a look at both.

The learnitfirst: a lot of videos, but it does take forever. I mean he doesn't seem to get to the point very...

Thanks Welsh Corgi, it worked.

What I find kind of disappointing though is the error messages that you get when you get it wrong. They don't provide any usefull info at...

No it doesn't seem to contain any code that would help me to copy paste (Special) a range in excel.

Unfortunately.....

If anybody has some code that does exactly that please let...

Did you check whether your package is maybe set to 64 bits?

64 bits won't debug as far as I know.

I've worked once for a mom and pop shop too and thought it was great at first.

Then after a while it became clear they had great difficulties acquiring new projects...

Thanx, that really helps.

You are both mentioning the use of Citrix. Are we talking about an Application Server that you log in to just like Remote Desktop, or are we...

do you recall what the actual link was?

"Microsoft Access is not a Client/Server Tool; It is more like File/Server.

If you do not go with ASP.NET then are you planning on using Citrix? "

Thanks for your answer.

Basically...

Have you got a boolean (yes/no) field in it?

May sound weird but make sure it has a default value of 0.

I would say: Test without the boolean field: See if...

Another lesson learned!

However:

The crux is not in the decimal(,xy) but in the 1.0!

(Sum([PremiumOnTime])*1.0/Sum([premium]) )

Just putting in the 1.0 makes that I get all the decimals that I could think of.

Nice!

Henk