Search results for query: *

MS Query is about the buggiest thing I have ever encountered. Is there an add-in somewhere either free or for sale that will do what MS Query should do? Including the query being saved with the worksheet? Marty

Hi everyone, I am trying to use MS Query from Excel to create a query against an Oracle (9.2) database. Most everything works just fine, but when I try to create a column alias by double-clicking on a column header in the bottom pane and entering a column heading, the SQL created by MS Query...

This is a piece of the table I am looking up in: CODE Description 2A Pocket 2Panel/1Track-2P1 2B Pocket 2Panel/2Track-2P2 2b ByPass 2Panel/2Track-2BY2 3b ByPass 3Panel/2Track-3CO2 3c ByPass 3Panel/3Track-3BY3 3C Pocket 3Panel/3Track-3P3 VLOOKUP doesn't work, because it is not...

I just got Excel 2003 installed on my computer. I did a simple 2-level subtotal. Some of the inner subtotals are appearing as outer, and vice-versa. This did not happen in 2002. Is this a bug in 2003 or is there something I need to set (can't imagine what).

If I select and copy text or an image and *then* open MS Word 2000 on an XP machine, I cannot paste it. The Windows Clipboard has been cleared. The only way I can accomplish the task is to *first* open MS Word and *then* select/copy. Is there any way to "fix" this? Marty

I have a column that contains a long comment field. I want a formula to tell me if a given set of characters exists in the comment field. I don't care *where* the substring occurs, just does it occur, true or false. Unfortunately the FIND function returns #VALUE! if the substring is not...

I am not the only one experiencing this. Mine just started today, others in the last few weeks. When I left-click on an empty part of the desktop, the start menu comes up at whatever location I clicked. Was this part of an automatic update that I was unaware of, or is something wrong. Can it...

I have become addicted to the scrolling wheel on my mouse. On Win98, it works fine, but on Win2K it doesn't. The mouse wheel works fine in other applications. It also works fine in the Preview Tab in CR. However, it does not work in the formula editor or the record selection formula editor...

I have a report which lists customers alphabetically. The detail of the report, which is suppressed, is invoices. The visible group shows total sales for the date range selected for the report. The boss wants the list to remain alphabetical, but he wants the line (or field) containing the...

I know how to get the total of just the top n using running totals. However. what I need is this total, then a line for "Others" and then a grand total. I can't seem to come up with a set of formulas that will do this. Any ideas? Thanks, Marty

I have a report that counts "problem units". I then have a subreport that counts the number of units manufactured of each type. The problem units are grouped by type, and the subreport runs for each group. I am using a shared variable to pass the result from the subreport to the...

Doing a "side-by-side" comparison of last year's sales YTD compared with this year's sales YTD. Using formulas to put the sum of last year's sales for each customer in one column, and this year's sales in another column, then calculating % change at the group level. Grouping on...

I am reporting off an ASCII comma-delimited text file. Strings are enclosed in double quotes. I am using a File DSN with the Microsoft Text Driver (ODBC). One field in the file contains a two-letter code designating a style of window, e.g., "DH" = Double-Hung, "SH" =...