Recent content by chromarog

Skip, again I owe you a tall cool frosty mug of a beverage of your choice. Seeing the logistics nightmare there, I'm afraid all I can do is click the Thanks link. And thanks KJV for moving the thread for me.

Nevermind, I reposted. Thanks, Rog...

I'm having trouble with the NZ() functionality. It works the way it should, I'm converting a null result to the number 3, but then my group by's are still seperating the results. SELECT T_VSMSMP2_BreakDown.WOTYPE, nz([T_VSMSMP2_BreakDown.PRIORITY],3) as PRIORITY...

It's an access 2007 query. I'll repost there or will this be moved accordingly?

I'm having trouble with the NZ() functionality. It works the way it should, I'm converting a null result to the number 3, but then my group by's are still seperating the results. SELECT T_VSMSMP2_BreakDown.WOTYPE, nz([T_VSMSMP2_BreakDown.PRIORITY],3) as PRIORITY...

Oops. Sorry, missed the first part of the question. I got all confused when the debug came up bupkiss. But thanks for the solution. It worked!! I had tried the delimiters but I had them enclosed withing the single quotes of my original code. For future reference, is something like this...

All I get is the same message I've been getting. Run Time error 3464 Data Type mismatch in criteria expression. And when I click the debug button this line is highlighted. Set rst = db.OpenRecordset(SUSQL)

I've googled and searched and I'm ready to give up. I never thought it would be this tough. All I want is to click a button to fire a query and have the result end up in a textbox. If the project wasn't going to build on itself and grow, I would look into Dlookup and such, I can't seem to find...

I have another question related to this. How do I get the results to a text box? I would like to populate the results in a text box for each "priority" from the resulting Sum field ABCD. Is DLOOKUP what I'm looking for? I've thought about a single button that fires three seperate queries to...

Oh and Dhookom, I'll have to look into that, there is another column that indicates that hours were put into the process but they were classified as a normal procedure and not a breakdown. I'll use your information for the next step in the project though. Again, much appreciated for all the...

Cool, thanks Skip. I didn't realize that. Thanks for that. Rog...

I owe you one. Thanks a million. Rog...

I need some access 2007 help. I have a form I'm working on and I thougth what I wanted was something pretty simple but apparently I'm doing it wrong or going about it the wrong way. I have a query that hit's a table that does some summing up. This is the results: PRIORITY RegSum OthrSum...

I've tried the start menu properties of showing and not showing, thinking that it would reset all the registry settings but no dice. The Internet Explorer Icon pops back up in the Start Menu but I still get the Open With dialogue box. My guess when this virus gets it's hooks into your system...

Oops, forgot about that part. It's IE7. And I did try the support link and no good. It still does the same thing. Kjv, the shortcut creation is just as good, the only problem is the shortcut that windows puts in the start menu has that Microsoft shortcut where when you right click, instead of...