Search results for query: *

No; I need to be able to select from Oracle, Excel spreadsheets, and CSV files, at least. May need to also use Access and/or MS SQL. In short, any ODBC database. Marty

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

Sorry Skip, I have tried omitting the AS, I have tried using double-quotes, I have tried using no quotes, and every combination of the above. The variations you suggest do work in TOAD, just not in MS Query. Thanks for trying, Marty

Sorry, I edited the statement incorrectly. The original had more columns projected, and did not have a comma following the final column name. The statement as given in Skip's reply gives the same error. I am sure this has something to do with the particular I did find a sort of work-around...

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

Thanks to all of you for your suggestions. Here is what I did: First, I put this formula in the column next to the codes (they are all 2-character codes) I wanted to look up, in a range named "MyList" =256*(CODE(LEFT(C4)))+CODE(RIGHT(C4)) Then, on the page where I wanted to display the...

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

The Registry mod worked. Thanks! Marty P.S. The "thank you" link appears not to be working.

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

This problem does not occur in Windows 2000. Only on XP Home (two machines with different users, that I know of). As far as I have been able to determine, the problem occurs with ALL other applications. I can paste into other applications, e.g., NotePad or email, just not Word. If I copy and...

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

Wow that was quick! And, if had a bit more experience with Excel, I would have seen it. Thanks!! martyr

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

Thanks, but I figured it out. The users who experienced this had recently upgraded video drivers from Diamond. The installation includes a "new feature" which, by default, enables a start menu pop-up. By clicking on the tray icon (a red & white diamond) and selecting Diamond Properties...

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

There is nothing in the Knowledge base about it. I tried changing settings for the mouse but that didn't work, either. Don't think CD is going to make any more fixes for 8.5. Anybody know if it is still an issue in 9.0? Marty

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

Thanks to everyone who responded. After trying them all, I think the one that will work best in this situation is the sub-report solution. Why didn't I think of that!) Marty

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