Search results for query: *

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

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 +...

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...