ollie

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.

"This is what not to do if your bird shits on you."

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.

Shaq is not a fan: http://www.huffingtonpost.com/2010/08/05/shaq-to-jim-rome-lets-rum_n_671656.html

Vinny Testaverde's not that old really.

Netbook.

Post-Pack.

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.

Little Bobby Tables!! That's one of my faves.

http://ottawafoodies.com/forum/3067

R.I.P. http://googleblog.blogspot.com/2010/08/update-on-google-wave.html

Geez, I had no idea he was ill. Still has a great sense of humour.

"I'm awesome." Reference #1

I can't believe this thread got this long without being hi-jacked. (Your early attempt notwithstanding.)

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.

Is it possible that baptiste's record doesn't match the other criteria? i.e. Award Date <= 2007 AND End Date >= 2007 ??

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

Try this! SELECT [Award Date], [End Date], [PI- LastName], [PI- FirstName], [Grant Agency], [Grant Title], [$ Amount] FROM C WHERE [Award Date] <= '2007' AND [End Date] >= '2007' AND ([PI- LastName] = 'baptiste' OR [PI- LastName] = 'macdermid')

Do you know what the actual table name? Is C the actual name? I don't have a copy of Access handy so I'm just guessing at the syntax.

P.S. If this is still not working can you send the entire query, including the FROM clause? Thanks!

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'