Search results for query: *

Sorry...I wasn't even thinking about the version having any real bearing on this problem...but you are right, I guess it could. I am working with version 9. Good point Madawc, thank you! Antiskeptic

I know I've seen this formula before...but I can't for the life of me remember it. *argh* I have a field that displays a number 40.5...I need it to display in hours and minutes...like this - 40:30 Anybody got any ideas? Sincerely, Antiskeptic

nope... I finally found th eprobelem...there was an extra field that was the culprit. Not an extra field that was just in there twice, but a TimeCodeDetail feild that needed to be eliminated. Everytime that code changed it would start the count over again, causeing a second row of data for the...

why would the Select distinct cause a problem with the CURSOR? I honestly don't know enough about this to know... And you are right about the Union All with the Select Distinct...just wasn't paying attention. Thanks for pointing it out. Anything else? Anybody? I don't have a clue why it...

oh, I commented out the and ptocnt<3 just to see if it would make a differnce, but it did not, and I forgot to uncomment before posting this... ~Brenda

Okay PattyCake245.. I'm almost there, but the CURSOR is not picking up all the possible "candidates". It seems to be skipping over those people that have more than one WT (Worktime) record per day. Almost like it's looking at the records and when it doesn't advance to the next date on the next...

This definitely looks like enough to get me started...and You don't know how much I appreciate your help! Thank you so much for your time, and I will let you know how it comes out. Just wanted to let you know right away how wonderful you are for giving this a shot. :-) THank you and you'll be...

okay I'll check back on Monday?

I have no choice...I have no other way of doing this...are you telling me that no one out there knows how to wrote a cursor...anybody, please help! I'm frightened!

I have never written a cursor from scratch...so I'm completely befuddled as to where to start, can anyone help me? I started this thread a couple days ago looking for a solution...and realized, and was told, that a LOOP or Cursor would be my only option...so here goes... I am working on a...

Don't know why I'm getting this error...very bizarre! I'm using CR 9.0 and I have a very simple report that works just fine until I go to put the parameters into effect in the Record selection My record selection statement looks like this: {rsp_RMS_ReconciliationReport;1.entry_date} >= {?From...

thank you very much for all your help...and beleive me I understand not having time to look this up, I was only inquiring if you happened to already know someplace to read up on it. I've already found something...so I think I'm on the right track. Thank you everyone for your help, and if...

And this is where I fail miserably...I've never done a cursor, and don't have a clue how to even begin one. I was thinking of a LOOP without a cursor...but a couple of the SQL guys around here say the same as you, that a cursor would be my best bet. But none of them know how either. We are a...

Okay..., maybe I just don't really get how this works. I'm getting GrpFld numbers of 999 or 345. Not exactly what I was looking for, so I'm wondering how this is supposed to be working. What number should be updating into the GrpFld? and would my theory of the Looping count work? Sincerely...

Donutman... we did it again...*ha* I will give this a shot and see where it puts me. :-) Thank you so much for your input so far. Thank you, Antiskeptic

that's okay...thank you for the attempt anyway. *ha* I wasn't sure I was understanding it...so I'm glad you wrote back .*haha* Any way to do this other than ASP? To all, My theory is this could be done with a loop. I just need to figure out how to assign the fields needing to be counted to...

Donutman... You must have responded as I was writing my last reply... did I answer your question at all, or do you still need more explaination? And you are correct about the holidays...if it's a holiday or they simply didn't have a timecode for that day then it just does not come into play...

actually anyday that is skipped is needing to be taken into consideration. I was just using a weekend as an example... ...so if I have: 8/3/04 PTO 8/5/04 PTO 8/7/04 PTO 8/10/04 WT 8/11/04 WT 8/13/04 WT 8/14/04 WT Or 8/3/04 PTO 8/4/04 PTO 8/5/04 PTO 8/6/04 WT 8/7/04 WT...

I am using SQL Server 2000. I am creating a stored procedure of which the output will be used in a Crystal report. But I need help getting the output right. I am making a payroll audit report to see how many consecutive days are taken off during a pay period. I have tried several different...

well, I tried yours vongrunt...but it's just running, and running...it's been running for over 10 minutes with no output. So I don't think that's it either this is what I used exactly...did I do something wrong? select A.[User],A.[Permissions],A.FolderPath from PermissionsByBaseFolder A left...