Search results for query: *

I'm sorry, I was looking at the code some more after I posted it (since I can do that from home), I'll pull all the scripts and try to find something relevant tonight and repost tomorrow. Thanks, Peter

Sorry previously I meant to fill in the blank on the xxx. But the script it is using is called Chat. Below please find the script. ;* Chat Script - Simulates old-style chat. * ;*************************************************************************** ;*...

I've tried looking at the script, there is a file called xxx that it says it uses on the screen that prints the report. I see events for key presses, but I don't see anything specific to the F9 key nor can I find anything that tells it to print. I will try to get that posted shortly. Again...

I checked and I am not seeing the status line change at all. All that happens is after it is done, then a message comes up saying the request was completed and press f12 to close the message. I noticed there was an option at the beginning that said Report Administration, would it be in there...

Link489 (TechnicalUser) Mar 30, 2006 Afternoon, I am new to Procomm as I just started working with reporting in my company and we use Procomm as our customer service statistics reporting. I have done some previous coding in Microsoft Access and have gotten pretty good, although I have no...

Afternoon, I am new to Procomm as I just started working with reporting in my company and we use Procomm as our customer service statistics reporting. I have done some previous coding in Microsoft Access and have gotten pretty good, although I have no formal education, so I don't know anything...

Actually I got it to work! Thanks for all your help. Peter

Sorry for the delay, I had the opportunity for my 4th of July vacation. But... Here is the SQL for the Aging 0-3 Query SELECT DISTINCTROW [Aging 0-3].Region, Format$([Aging 0-3].[Effective Date],'yyyymm') AS [Effective Date By Month], Count([Aging 0-3].[Group # (source system)]) AS...

I tried changing it to: < Format(DateSerial(Year(Date()),Month(Date()),1), "yyyymm") But I get the same results as some of my other expressions, it seems not to calculate these as dates or as numbers I don't understand it, it will return results correctly if it was last month, but anything...

I gave that a shot, unfortunately w/ that it returns no results I think because it will format the date into a mm/dd/yyyy format that doesn't match, and unfortunately I can't use that kind of format because i need to group by whole months. Thanks for the reply though!

Hi, I am new to SQL and generally end up using the functions built into the query, I have to bucket records by a date by month. So far I have my first query re-format it to: Format$([Aging 16+].[Effective Date],'yyyymm') I used yyyymm because w/ the standard 'mmmm yyyy' it seems to calculate...