Search results for query: *

I'm new to teradata, and some of the differences really have me stumped. From what I've read I need to replace wm_concat() with a recursive query to aggregate rows, but I'm having a hekuva time figuring it out. Any help you can provide is appreciated. For the sake of the discussion, I have a...

Okay, this is kind of convoluted, but hopefully someone's heard of this. I have a spreadsheet (sheet name: report) I created in excel 2003. In cell report.a1 I have a logo (image file). Then in another column, cells report.AT12 to report.AT509 I have a data validation setup. The validation...

example column1 column2 column3 columntotal row a 1 1 1 3 row b 0 1 3 4 row c 10 0 1 11 row d 3 2 2 7 In cr 9 or 11, is...

I posted this (incorrectly) in queries, hoping I get a better result here... Any help you can give on this would be great. I've got everything ready but the "TO", and it's giving me a hell of a time... I'm trying to get my form to send an email to the "recipient" that is listed on the form...

Any help you can give on this would be great. I've got everything ready but the "TO", and it's giving me a hell of a time... I'm trying to get my form to send an email to the "recipient" that is listed on the form. The email is basically going to a wireless carrer, which will make an SMS...

I have two formulas that count the number of Males and Females in each contract. I want to have a pie that shows m vs f results (for some reason we don't like numbers- we need pictures). Is there any way to create a pie from two seperate formula results? Michael Phipps Technical Business...

In my detail section I have a field that has what is basically a concatenation of several other objects. I'm looking for a way to count the number of times a value (X)appears in the field. Example: Field Value: XXXYZUYYCX formula result: 4 (because the value X appears in the field 4...

I'm stumped on this one... I have 25 text fields, all 5 characters long. The fields contain error codes for the row, so none, some, or all of the fields can be filled in. What I'm trying to accomplish is to write a formula that translates all of the text fields into their english...

I have a boatload of SQL queries that I've saved over the years in the GM filters section, and I can't seem to find a way in GM to thin them out at all. Any ideas? GM CE 6.6 Michael Phipps Technical Business Analyst Mercy Health Plans

This is a bit confusing, so please bear with me. I need to get the top 5 scores from an array of 35 scores in a table... I have an access database with a table called "qualityheader" that has 36 different fields in it to record a score for each of the 36 indicators. Some scores are 0 or 1...

I have two issues, and I think they are related... I'm working on a win98 machine with IE6, and it hadn't been updated in some time. I was trying to complete all of the updates through windowsupdate when the "Scan for Updates" button failed on the website. When I click on "Scan for updates"...

I'm sure this is simple- but I'm just not as good at access as I'd like. What I need is to enter a number in a form, and see if that number exists in a table. In the table, the first 3 charaters are in one field, and the remaining characters are in another. So, the source table looks like...

Is there a way to revert an unsecured .pdf back to a document or txt file? Michael Phipps Technical Business Analyst Mercy Health Plans

In a field that I have set properties for hyperlink, I have placed a link to a file. I want to create a button that will open that file on the related form. Can anyone give me some ideas? Michael Phipps Technical Business Analyst Mercy Health Plans

I'm looking to set a file link in an Access form , and would appreciate any advice you can provide on how to add a "browse to" button in the form. What I am looking for is something along the same functionality of the Start/Run box in Windows. Thanks for your help! Michael Phipps...

I have added a new FAQ to this forum listing some other resources for support. Tek-tips is a great resource, but it's always nice to get other opinions too... Michael Phipps Technical Business Analyst Mercy Health Plans

Has anyone heard of a .wdb format? I think it is some kind of database of spreadsheet file... Wotsit hasn't even heard of it. Any insight would be appreciated. Michael Phipps Technical Business Analyst Mercy Health Plans

This is a sales report crosstab in which a record may have a sold date matching the current month in one of three effective date fields. I have a cross tab that is pulling from one field (Sales Rep) in the row, and three in the column (potential effective dates): | Effective 1...

Does anyone have any insight into the following error: "xbase Error: Bad user specified Key Expression" followed by "Error detected by database DLL" It started happening with one report and has begun with several others. Many of the reports are still working just fine...

I want to have a field in a form produce the name of the W2K login in use, or the machine name of the person looking at the form. So for example, a hidden field that logs the name of the person or PC that was used to make the entry of the other fields on the form. Any ideas? Michael Phipps...