Search results

Yes, it is VERY slow. That is why sometimes I have 'hiccups' when posting to a thread. I often time have to go in and delete the double post.

I've got it working now. Here is the final code. intSecondaryTime: IIf(IsNull([dtmSecondaryReceived]),0,IIf(IsNull([dtmSecondaryComplete]),0,EntryAge([dtmSecondaryReceived],[dtmSecondaryComplete]))) Thanks,

Yes, I tried that too, I think the problem is that when it returns a 0 it goes to the defualt date/time of 12:00 am. I think that is playing havoc with my Entry Age Mod. :(

Hi guys, I have a mod called EntryAge. It requires two arguments. A start date and an End date. I'm trying to use it in a Query, but I am running into problems because there are times when the Start date and the end date are both Blank. I've tried this nested statement and it keeps...

Nope had no idea that MVS was the OS. I am use to JAVA, ASP.net VBA, VB 6.0 and now VB.net. That is what I am use to using. I suppose I am heading into a different ball field. They class has a 100% passing rate. They say they only select candidates that they fill can pass all the courses...

Thank you Brian, late is ok. It is just the thought that counts. Besides, you just retired and I'm starting my Career. Got any tips so I can have as long and productive career as you have. I was brave and asked for the Agenda for all the classes. :eek: :eek: Wow, I'm in for a HUGE change...

Ahh, thank you, you are to kind! I've got 1 week left before I start. ~YEAH~

Being that hind sight is 20/20, I think George would have been better than Uranus. Uranus isn't taken very seriously. :D

Can you make it see 01 instead of 1? I really couldn't tell you without looking at your DB. Can you zip it and upload it for me to look at?

Have you tried to add the table name infront of the field name. ? See below: Format(BenefitCharges.StatementPeriodMonth,"mmmm") AS Expr1

Also, another option is to remove the formatting from that field. Leave it as StatementPeriodMonth to make sure what numbers it is pulling. Because the formatting should work correctly.

Can you please paste a copy of the SQL for your query?

*wicked kitty grin* Muhahahaah!!!!!! Yes Richy boy??

If I'm thinking correctly you can just the format function to get the results you want. in that field put Format([fieldname], "mmmm") that should return the full name for that month.

Has anyone seen Fuzzy! I hope they are doing well. If you're out there, let us know you're ok deary! Good luck on your new adventure. :D

Need icecream and Ice Cold milk. Winter time, Ice cold milk and icecream as well. I love Warm Apple pie......*purrsss* Opps, I ment to say old. :p

Ahh, I see you dodged the old man comments I made. *walks back out, no longer worried* :cool: Yes it is Apple Pie and Ice Cold Milk....Yummy...yummy... Butter Milk is nasty....

I thought that was absolutly wonderful. I figured all you older guys would enjoy it. I don't know why y'all are whining over it so. I mean in a few years y'all will be there as well.....:D :D *ducks and runs for cover*

Are you pretty good with the stick and balls Richy boy? Can you sink them pretty well? ;) It sounds like a fun game. I wouldn't mind trying it out myself. :D

All the same, it sounds like fun. I even have my own pool stick. :eek: :D ;) I would love to find a place around here that played that style. :( Sadly, I'm sure I won't. I guess I'll just have to hop a plan to the UK to play skittels. :D