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

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?

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

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

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