Search results for query: *

I am trying to make sure account names in two tables are the same, but this update query is failing. What am I doing wrong? update s set s.account = a.account from account a inner join accountsummary s on a.accountid = s.accountid Thanks, TBH

Can someone confirm for me what the integer returned for these four levels of field access would be in VB 6? Unlimited Access Read only Read/write No Access

If a field has been added to a table used in a past report, how can I gain visibility to that field? It won't let me use it while editing the report. ~tbhgriz

I have a complex SQL query that used to be run in SQL query analyzer that could be used in a crystal report. When I add the tables that are in the query to the report and then paste the SQL into the View SQL window in Crystal, everything except the Select portion of the statement copies over...

Is there a way to return distinct rows only in the detail lines of a report?

I have a SUM field for column A Total Order Qty, and column B is a formula field that totals up Only certain orders. I am trying to then have column C that is B/A but it always shows 0%. Any idea why that happens? Kind Regards, Todd

I didn't realize that it resided in the WINNT directory (W2K). Thanks for getting me to see that...problem solved.

If a machine running MSSQL needs to update the enabled protocols in the SQL Client Network Utility, can it be done without actually installing that software? Are those settings available to change either in a file or from the command line?

Thanks...You information was helpful and I didn't know one null field would hide the whole row. In case anyone has this issue again here is what I got to work: dim add1 as string dim add2 as string dim city as string dim state as string dim zip as string If isnull({ADDRESS.ADDRESS1})= True...

I have Account and Address tables linked on AddressID. If I structure a report to show the Account, Address1, City, State, Zip as individual fields then each account row indeed shows the corresponding address info. I merged those fileds into a formula as follows: {ADDRESS.ADDRESS1}&&quot...

My note was confusing...The result in my last note was using 2 groups and the TopN sort. Using a Formula of Account and order type as the only group and using the TopN worked like a charm and gave me results like the third post in this thread... Thanks, TH

Ken, That was helpful and did exactly what i was trying to do! While TopN sort does sort SUM fields, it did not allow the groupings to be listed on seperate lines as in my example. ie: it did this... Acme truck 1000 (highest order total account Acme car 850 (and...

The Nsort sort of works...let me see if I can better explain my situation. For instance these 2 columns, with the same account name possibly more than once if they ordered more than one product type. Quantity is a sum of orders based on type. I want the highest quantity on top and descending...

As far as I can tell in looking through old posts it isn't possible to specifically sort by a SUM field, but is there any way of accomplishing that? I basically have a listing of accounts and the SUM of their orders but want it to show the highest orders first and sort descending. Any help...

Here is what worked... A:link {color:&quot;#000080&quot;; font:normal 10pt &quot;Arial&quot;} A.lnk2:link {color:&quot;#000080&quot;; font:normal 10pt &quot;Arial&quot;; font-weight: bold} <a href=&quot;University%20Sites.htm&quot; class=&quot;lnk2&quot;>University Sites</a> This link was...

Here's an example of what I did and it didn't work...Do you need more than version 5.5 of IE to support classes? All links are the default bright blue with 12 point Times new roman... In Header: A.lnk1:active {color:&quot;#000080&quot;; font:normal 10pt &quot;Arial&quot;} A.lnk2:active...

I am new to CSS and have been playing with A:link style in the header which is working great except that one column of links I have needs to be different from ther rest of the links on the sheet. How can I override the style, or can I create a custom style in the header and apply it to the...

If I have a Report grouped first by user and second by account with suppressed details section and group footers for both account and user, I can manage to get sum's for items in the detail fine...But I am having trouble creating a sum of a column that is listed in the account group footer (so...