Another IPA fan here. Lately I've been enjoying the Devil's Pale Ale (666) from Great Lakes. I'm also drinking the Headstrong IPA fairly regularly. P.S. I've seen Hoptical Illusion at The Beer Store.
Yeah, that worked out well, nice meeting youse too! I hope you enjoyed the rest of the Saturday bands. My avatar is our "end of the night" picture with a bunch of randoms.
I'm more annoyed by the whiney broadcasters that complain about having to talk about Favre's retirement once again. Don't blame Favre, blame your producer. It really is possible to ignore this story if you want. I hope Favre comes back. I am loving his "middle finger to everybody" second act.
Well that last query you posted LOOKS to me like it should work if all the other conditions are met. The only thing I can suggest is to go over the data with a keen eye and see if there's something "off". e.g. Does 'baptiste' have different capitalization in the database? Where are all the other nerds? If you're still stuck you could always e-mail me a copy of the database and I can take a look when I get home. PM me if that's an option.
OK, I think I've gone too far in trying to clean up the sql statement. Can you send me a copy of the one that works (without the OR stuff on the last name) and I'll try to work from there?
Sorry to repeat myself, but are you sure the table is named just 'C? That looks more like an alias to me. Oh well, try changing to FROM line to FROM 'C
Leave the spaces for now, that was just a style note, you can still get your query to work. Try this: WHERE C.[Award Date] <= '2007' AND C.[End Date] >= '2007' AND (C.[PI-lastname] = 'baptiste' OR C.[PI-lastname] = 'macdermid')
First, take a closer look at my use of the "IN" keyword in my example. As for this... I see a few things wrong here... 1. quotes used as delimiters should be single i.e. '2007' and NOT "2007" 2. I'm not sure why you have a single quotation mark in this part: ['C].[Award Date] 3. Style note: although Access lets you, I'd avoid putting spaces in my field names; you'll avoid potential pitfalls 4. Remove that semi-colon and replace it with AND Try those fixes and report back.
I'm not sure if you're looking for something specific or generic but this would work: select * from tablename where lastname in ('baptiste ', 'macdermid') OR select * from tablename where lastname = 'baptiste' or lastname = 'macdermid'