Recent content by MRyerson

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