Search results for query: *

Hello. How do I remove date formatting from cells that are blank? I have date of birth, formatted as mm/dd/yyyy. If the dob is blank, then the / / marks are still showing up. Anyone know how I can remove the / / from those folks that have no dob? Thank you!!!

Hi. I have this list of queries from a db that I didn't create, but that I have to modify. I was wondering if anyone can tell me why the icon appears grayed out? One is not, but the rest are. Thanks as always! I'd have attached a pic, but can't figure out how to :(

Hi. Anyone know why I'd be able to see this option in all my other databases, except one? Is there a setting or code that prohibits this option? I am not the database owner, but am trying to troubleshoot it. I can not see any of the tables, queries, forms, reports, modules, or macros. The...

I'm getting this error when ONE user tries to open this database. All other users can open with no issues. I've never seen this before. Anyone have any ideas on this? Thank you!

I've never seen this before. All of our users can access the db, except one. I'm having trouble finding any decent info on the net. Can anyone give me some clues as to why this is happening? Thank you!

Hello. I am working on a 'report' in access that will be exported to excel. The end users do not have access, hence the excel medium. I'm trying to create as much as I can in access. So, I have 30 columns of information. Each column will need a drop down box for the user to select an...

Greetings all. Hope this is the right spot for my question. I am creating a query in access off of one table. The table I am using does not contain the required code of AB01. This code should appear on all rows of returned data. I am not allowed to add this code directly to the Access...

Hi. I'm wondering if there is an easy way to identify the items that are mismatched. The error 'data type mismatch' is vague. I know what it means, just don't know which items to check first in my query. I'm looking for general ideas, or tips/tricks that this super user community might have...

I have a document that has a TOC. I have used bookmarks to get to the different subjects. All works fine there. However, I've also used bookmarks to send back to the TOC. So clicking on the topic heading in the document, takes you back to the table of contents. That works fine. What is...

Hi. Hope I'm posting this in the right group. Apologies if I'm not, and suggest a better place. Anyway, I'm at a new job, where their directories are OUT OF CONTROL! Folders nested 5-6-7 folders deep, duplicates, no structure, no rhyme or reason for their setup. Does anyone have any...

Hi. Anyone know if there is a way to change the size of the pipe that appears when changes are made in a document? Track changes is fine, ballons are turned off, so only the pipe appears, and changes are in red. Was wondering if there is any way to increase the size of, change the color of...

I have a column that contains numbers, but they are formatted as special Chinese (PRC). I need these to be text. Example: 000001 and 340781658648631, if I convert these to numbers, the 0's are trimmed off, but I need to keep them. If I convert to text, they are also trimmed off. I tried...

I need to find the first instance of data in a row in Excel. Not just one row, but 38,000. I am tracking enrollments. Each column is a week number. Each row is an individual child. Each child enrolls in a different week. Each cell contains tuition amounts (which indicates enrollment for...

I have two tables, one(1:1 relationship)contains a unique Id and an amount, the other contains the unique id and several records per each ID (1:many relationship). I need to return several different column values to the 1:1 table from the 1:many table. Is there a way to return multiple cell...

Anyone have any idea how to make this in Excel? I can't seem to find anything in the help files or on the web. How to's or links are appreciated. Thank you!

I know this is the wrong forum, but I was hoping to catch Ties. I have a feeling you'll know this as you are super smart. I have a frequency table that is consistently omitting 1 from my counts. I have x number of y, and when I sum x its one short in at least one of my bins. My formula works...

Sorry if this is the wrong forum to post this in. I have a frequency table that is consistently omitting 1 from my counts. I have x number of y, and when I sum x its one short at least one of my bins. My formula works perfectly if I do the frequency on all records, if I start filtering the...

Hello Cognos Analysis Studio users! Is there any way to copy an analysis in order to analyze off of a different cube? I know in Report Studio you can copy the report spec, and paste it into a blank report and change the data source there, but I can't seem to find this functionality in Analysis...

Is it possible to create a data set in Report Studio? Example: Region 1 2 3 4 5 6 Region's 1-3 will be in Group 1, Region 4-6 Group 2. I thought there was someplace I could create my own data set? Is that only in Analysis studio? Thank you!

I am working with Analysis Studio (Cognos 8.4). My measures are doubling up. Any ideas why? Not as familiar with Analysis studio as I am with Report Studio, so any help is appreciated. Thank you!