Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
I love databases (I used Filemaker at my last job), but the reason I do things in Excel is that either Excel or Access is available to me, and I don't have the skills to make Access work for other people, or really for me. If I have a list of 100 names and addresses that I someone to be able to do mail merges with, it is just easier to use excel, which the other Admins understand than Access. Filemaker is not supported and activiely discouraged by our IT department. I have one Access database for registration, and they eliminated the Access database support position from IT, and it is so hard to use!
ETA- I would do what meara said (replacing the Y and N with a number, and then doing a search and replace for the number to put in the age range.
Let's say I do a search and replace on Age Range 0-3 to turn all the Y's into "0-3" and a search and replace on Age Range 4-6 to turn those Y's into "4-6" - is there an easy way to convert a row of text values into ONE cell with those values separated by commas?
You can use the CONCATENATE function to do that, Jess.
Eta: or &, that might be easier for a long string. =A1&","&A2&","&A3 etc
See and I was thinking of if statements. Concatenate would work just fine.
I think I have finally beaten the Excel query into submission. Of course my frustration with it spurred me into putting more time in after I had submitted my timesheet, so that will become Saturday time. If the recipients don't like the results, they can stick it.
Yeah, I was thinking IF, too, but without actually seeing the data and how its arranged I'd have a hard time formulating something helpful.
Stick it to the man, Suzi! By working more than you meant to...that'll show 'em.
I purchased a Lacie Cloudbox NAS. Not a RAID system. Just wanted an iTunes server. My computer is consolidating my library on the new 3 TB drive. The progress bar is a thin sliver of green, and it's been nearly 2 hours now. I get the feeling this will be going when I come home from work tomorrow. Now to figure out how to get the AppleTV to see it directly. The Xbox has no problem. We shall see if I can figure it out.
ETA:
when I woke up this morning, the progress bar was about pinkie wide. I think it's started on the video stuff now. Which is about a TB worth.
WTEVERLOVING FUCK.
Google is dumping Google Reader, the one thing that keeps me sane during the work day (aside from here):
[link]
There are no alternatives!
Nah, just kidding. But I get why they want to consolidate. How much penetration does RSS have into non-tech savvy users? I did get someone email me telling my provocateuse RSS was down, but I'm filing them as passive aggressive, since it's not down--I just haven't updated in a millenium. I hope they appreciated the one new record after I responded.
I should check web logs, though.
