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

WOW That did it! Thank you so much. I really appreciate all of your help. Michael Phipps Technical Business Analyst Mercy Health Plans

Thank you! glad I was just missing something. Here's the text from the immediate window: SELECT TBL_CARRIERS.PREFIX & TBL_RECIPIENTS.PHONE & TBL_CARRIERS.SUFFIX & TBL_CARRIERS.DOMAIN AS theRecipient FROM TBL_RECIPIENTS RIGHT JOIN (TBL_CARRIERS RIGHT JOIN TBL_MESSAGE ON TBL_CARRIERS.CARRIER =...

Thanks for continuing to help! It didn't work (still get the "no current record" message), and I set the break point as instructed. When I click the button it just takes me back to the code with the line hilighted. I've included the code I have in there now: Option Compare Database Function...

Okay, now I'm getting another error 3021- no current record. I'm in the form, and have a test record up, but apparently it can't see that. The debug hilights FOO = rst![theRecipient] Is the problem possibly in the part of the sql where I'm asking it to read the form to get the...

I'm running into an error when I try to use that. You're pretty much speaking greek, so I really appreciate the time you're taking with me. The error reads: When I click Debug, the following is hilighted: Set rst = dbs.OpenRecordset(strSQL, dbOpenSnapshot) Any help or explanation you...

Hey- thanks for replying! "FOO" is basically the result of the query I'm tryng to get work. I can write the sql to get it to work, but getting access to put the result in the TO line is my problem. I have to admit I'm a bit of a n00b at this stuff- I'm more of a crystal/BO guy, so this 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...

Each record in the database has space for up to 6 people, so each record can have multiples of each gender. I figured out how to add up the males vs females, and now I can get the total number, but I don't know how to turn it into a pie. Michael Phipps Technical Business Analyst Mercy Health...

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

you are a goddess among mortals. Thank you! Michael Phipps Technical Business Analyst Mercy Health Plans

I can't seem to get it working... Here's what I changed it to: numbervar i; numbervar j := len({@age compiler}); numbervar k := 0; for i := 1 to j do( if {@age compiler}[i] = "60-64" then k := k + 1 ); k The possible values in the field (which may have multiples of each of these values) are...

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 want to make sure that I'm getting this right... each of the 25 text fields can have one of the error codes. The error codes are all the same, and can appear in any of the 25 fields. So, if the error codes and their decodes are: V0100- invalid Void 00200- ineligible DOS 00300- invalid...

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

yep. I'm lost. Can you help me out with some more details? It sounds like you are taking every score and making it a 1 column row for all users. Is that correct? I think this may be way over my head, but I'm interested in your idea. Michael Phipps Technical Business Analyst Mercy Health...