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...
...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 descriptions, I put this...
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).
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
...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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.