Search results for query: *

Summary columns are what they sound like - a column that contains the sum of one of the other columns. Say you have a field F_TOTAL that is a column formula that multiplies QTY and PRICE. You could create a summary column CS_GRAND_TOTAL that sums the F_TOTAL field. Then you could put the...

Make sure that the placement of your CF field in the data model allows it to see the data it is using in the formula. For example, if your QTY1 and PRC1 fields are within the G_SALES group, try putting the CF field within the G_SALES group as well. Good luck.

Doh, my bad. I had the wrong thinking cap on. Try something like this instead: SELECT Table3.appStatusDate FROM Table3 WHERE (((Table3.appStatusDate)>=#30-09-2002 15:04#)) AND (((Table3.appStatusDate)<=#31-10-2002#)) The problem I see is that since your date format is in a different order...

Try something like this: select * from myTable a where a.appStatusDate between to_date('30-09-2002 15:04','DD-MM-YYYY HH24:MI') and to_date('31-10-2002','DD-MM-YYYY'); Good luck.

The problem is that the 'Percent' format always gives 2 decimal places. Try setting your format to the following instead: #.######% That should give you up to 6 decimal places, and it will convert numbers to a percent. Good luck.

Try this: 1.) Use the wizard to design a query that finds unmatched records based on one field, say CompId 2.) Open the query in design mode 3.) Create a new join for the other column (click on ElementId in one table and drag a link to the ElementId column in the second table) 4.) Highlight the...

Instead of: <CFIF IsDefined('qry1')> <CFLOOP QUERY = &quot;qry1&quot;> <CFHTMLHEAD TEXT = &quot; <META NAME = 'description' CONTENT = '#qry1.content#'> <META NAME = 'keywords' CONTENT = '#qry1.content#,'> &quot;> </CFLOOP> </CFIF> Try something like this: <cfset contents =...

Try something like this: select v.insid, cp.ProcsOutstanding from V_INS_ENTS_OUTSTANDING v, (select count(*) ProcsOutstanding, vmp.insid from v_monitored_procs vmp group by vmp.insid) cp where v.insid = cp.insid; Good luck.

The problem stems from the fact that null is not actually a value, but rather the absence of data. Because of this, you can not successfully compare it to a value. Access doesn't have a value, so it simply returns false to any inquiry containing null (other than a null=null relationship). If...

Try setting your format mask to $99,999.00 I'm not sure about forms6, but in forms 4.5 including the quotes around the format mask changed all the data to #########. Try leaving them off. Also, make sure to have five 9's before the decimal (instead of the four indicated in your post). A...

Try this instead: SELECT SURGERY.PTID, SURGERY.PTINIT, SURGERY.SURGDATE FROM SURGERY WHERE SURGERY.SURGDATE<DateValue('8/1/2000') ORDER BY SURGERY.PTID;

Try something like the following: <cfparam name=&quot;URL.OrderClause&quot; default=&quot;Ascending&quot;> <cfquery Name=&quot;EmployeeSearch&quot; datasource=&quot;cftrain&quot;> select e.salary from employees e <cfif URL.OrderClause eq &quot;Ascending&quot;> order by salary <cfelse>...

You might be able to. I have set up different timeout periods depending on the server the application is running on (devl vs. prod). My code looks like this. Note the setclientcookies=&quot;Yes&quot; text, I didn't notice it in your code. Since cookies are used to stored the session...

Not sure if it will solve your problem, but I did a search on Microsoft's technet for Access 2000 and AOIndex. It came up with the following article: http://support.microsoft.com/support/kb/articles/Q306/2/04.ASP Give that a shot, hopefully something in there will work out for you. Good luck! KR

Kjell, The problem you are running into is the LONG datatype. There are many restrictions concerning LONG datatypes that do not occur with other text datatypes such as VARCHAR2. One of these restrictions is that a LONG field cannot occur in the WHERE clause of a select statement. For more...

I don't know of a straight forward CF tag that will accomplish this for you, but the following code/logic will work: <!---Set the value of the two dates---> <cfset date1=&quot;11/01/2001&quot;> <cfset date2=&quot;12/01/2001&quot;> <!---Get the number of calendar days between the two dates--->...

Hello. I have a form that requires the user to enter information. One of the fields on each of the records is an approval list box. The values contained are &quot;Proposed&quot;/&quot;N&quot; and &quot;Approved&quot;/&quot;Y&quot;. When the user changes the list box to &quot;Approved&quot...

GunJack, Thanks, I did a little bit of a variation on your idea, and it should work pretty well. Here is the code I used: <textarea name=&quot;diagnostics&quot; rows=&quot;4&quot; cols=&quot;50&quot; wrap=&quot;virtual&quot; readonly>#Error.Diagnostics#</textarea> This way, the user sees it...

Hi GJ. Turns out I was in a bit of a rush to leave yesterday, so the only functionality I had time to test was to see if the error message disappeared from my email form. I honestly cannot get either of our ideas to work (either the urlencodedformat or replace). I think the problem is...

Actually, I found another way, right before I read your message. I used the URL_Encode() function to enclose the variable to prevent the problem you described. [code]<input type=&quot;hidden&quot; name=&quot;diagnostics&quot; value=&quot;#URL_Encode(ERROR.Diagnostics)#&quot;>[code] Thanks!!!