Recent content by cubi

What I'm trying to do is to have flexible decimal places, so to speak. I want excel to show however many decimal places I type in (or none), but that it always has comma separators. Thanks.

Hi all, Is it possible to format cells in Excel to have comma separators for numbers but not have to specify the number of decimal places? Thank you.

The query is kind of long, but it looks like: SELECT DISTINCT AGENCY_ID, PROGRAM_ID, ACTIVITY_ID, ... DESCRIPTION FROM AGENCY, PROGRAM, ACTIVITY, ... WHERE ... I used DISTINCT to get unique values. The text value in the DESCRIPTION field es truncated. Without DISTINCT the query returns 3...

Hi, I am using Access 2003 and one of my queries returns truncated text -- truncated from the front. I use DISTINCT in my query. When I remove DISTINCT the texts look fine. Has anyone seen this problem before? Thank you!

Hi, I am using MS Access 2003. Is it possible to format a text field to make some characters superscript or subscript? Thank you.

We are in the process of getting Office 2002. Thanks for your input!

Hi, I protected a worksheet and unlock some cells for editing. When I do that I cannot sort or use data filtering of the worksheet. Is there any way around this? Thanks.

Hi, Does anybody know what this error mean? An incorrect structure was found in the pdf file. It happens when I try to delete or replace a page. Thank you

Hi, Is it possible to configure MS Outlook to read my ____@msn.com emails? Right now I use MSN Explorer, but would prefer Outlook. Thanks.

Thanks for your replies. I used Word Art and selected the desired rotation. I am curious as to how to invert regular text.

Hi, Is there a way to invert text in Word, i.e. turn it upside down? Thank you

Hi, I share a folder, which contains two files, on my computer with a few people in my company. Is there a way to have Windows send me a message when one of these two files is modified? Thanks.

Correction on my post. The datatype is CLOB, NOT BLOB. Sorry.

Thank you for your input! I will try them.

Hi, Is there a way to convert a table column from BLOB to VARCHAR2 while keeping the data? I inherit a database, and of the tables has four columns of type BLOB, but the data in them is just text. I want to turn those BLOB columns into VARCHAR2 but preserving the data. Thank you.