Recent content by RosieMP

Wow, I feel like a moron. I was looking in the wrong place. But I feel like a moron with the right answer, which is the important thing. Thanks!

GAH! Not sure whether this is the right forum for this one... Can anyone suggest why my status bar isn't working? If rRaw Mod 100 = 0 Then Application.StatusBar = "Processed " & Format((rRaw / BottomRow), "%") Else Application.StatusBar = "whatevah" End If Even with bad...

I don't get an error on the vlookup, I just get nothing returned. I use an if/iserror/vlookup combo for vlookups so I don't get '#value' if there's nothing found, so the basic configuration is, if it's an error, return the value "not found", if there's no error, then return the value I'm...

I tried that text to columns idea but the tick mark doesn't appear in the wizard -- you can see it in the cell only in the formula bar, but not in the cell just by looking at it, and it doesn't appear in the wizard at all (no leading spaces either). (Good thought, though.) The multiply by one...

I've been stuck on this for months--can anyone help? We manipulate a lot of data that comes out of SAP/BW. The BW stuff is crazy with formatting--much of it specifically formatted as text (with a little ' mark in front of it.) There is nothing I can do about this. It's something to do with how...

Thanks for helping me thinking this out. Re. ankles: probably the same as clavicles. (Don't everyone apply at once.)

They might have been around in 1802. They sure have 19th century corporate policies. We got an email telling us women weren't allowed to show their clavicles. Okay Remou--not sure if we're envisioning the same thing.... Here's what I'm thinking: tReportCategories ReportCategoryID...

What about this for a solution: Rather than a change date for the raw data (and maybe this is what you were saying), what if I include date iterations in the reporting category table? That way the reporting combo has a date attached--IF I want to do some combination of our reporting codes in...

Thanks Fniely -- I agree re. codes v. descriptions; the other upside being that its easier to write queries by a field code than by some big honking description field...What I want to use for a code is the concatenated value of the collector and the internal customer type (credit group), so I'd...

To be clear(-ish), I'll have at least two tables, the raw data (main) table, and the reporting code table....

I don't have much flexibility as far as normalizing the data or setting up tables beyond a table to hold the reporting category. I get a text dump with 12000 lines and something like two dozen columns. I won't have a collector table, or a customer table, it's not going to be normalized. Or...

Okay, one more question for the day... This is a philosophical question, and I've gotten conflicting responses asking around the office, so I'd like to find out what's recommended. I'm building a table to hold a history of open accounts and report on it. Reporting buckets are based in part on...

Thanks both! I took the 'no brainer' as intended :) I'm glad it's a clear answer. I think what got me is that it seemed like a giant Excel spreadsheet.

Hi folks-- I'm having a hard time deciding between design decisions that may or may not make my life miserable in six months. I need a database to hold a significant amount of data about aging accounts. I'll add about 12000 lines each month about how much money various customers owe, and how...

Okay, I think I figured this out, so for anyone who finds themselves in a panic this is what I did: I changed the be table name to what I wanted, then deleted the link in the front end, then I readded the table link in the front end. It didn't seem to be enough to just change the name in the...