Search results for query: *

OK I see that my description of the issue is poor... I apologise. I have created a calculated item called daysold which is CURRENT_DATE-statusdate from this (daysold) I need to group by count of a status that falls within the 1-7 8-14 etc so the output will appear similar to.. 1-7...

Thanks I will go and try this now!!

Hi, I have a crosstab query that counts how many jobs are on a status by date I need to group the date by 1-7 8-14 15-21 22-28 & 29+ I have tried to use width_bucket but i cannot get this to work. Does anybody know of a way to group date in increments of 7 then 29+ Thanks

LOL

Hi all am trying to trim leading spaces in an ACE report the leading spaces are from a smallint. I thought it was easy but struggling like hell!! Thanks in advance. Dave.

Hi, I need to get rid of whitespace and a trailing charecter return at the end of the line ive tried trim(fieldname) but just get an error. Also i believe chomp() may get rid of the charecter return. I have no idea how to use chomp() can anybody help? Here is a snippet of the code.... function...

Hi, I have written an idc file to pull data from our database to the .htx page everything is returned to the .htx other than the count?? Has anyone had this issue? If so please help. Here is the code: Datasource: serv Template: mprc08.htx SQLStatement: + SELECT st_description + FROM statcode +...

you could also try isql -s

Thanks PHV It's so obvious when oyu see it!!!! My hair can go back to its natural colour now.

Hey thanks i will go and try it now!

I would get the latest drivers for your monitor.

I had a similar problem. In the end we lowered macro security to low and this seemend to do the trick for us.

Hi everyone, I have been trying repeatedly for days now to write a macro to generate random numbers. I need to generate 23 unique numbers in 5 columns. I have found a macro that can do one column at a time but i cannot modify this to work over the five columns. Here is the code for you to look...

Does any body know how to change the Bypass key on MS Access from the shift key to something else? I have got an autoexec that runs when the program starts. However some clever b*****d has discovered how to hold the shift key down to overide this. And therefore keeps changing all of my settings...