Jump to content
Jambands.ca

Access question for any nerds out there


Groove Fetish

Recommended Posts

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.

Link to comment
Share on other sites

lets see the dataset for this:

SELECT [Award Date], [End Date], [PI- LastName], [PI- FirstName], [Grant Agency], [Grant Title], [$ Amount]

FROM ['C]

WHERE [Award Date] = '2007'

Then the dataset for this:

SELECT [Award Date], [End Date], [PI- LastName], [PI- FirstName], [Grant Agency], [Grant Title], [$ Amount]

FROM ['C]

WHERE ([PI- LastName] = 'baptiste' OR [PI- LastName] = 'macdermid')

Link to comment
Share on other sites

ollie fixed it...

this is the script that worked:

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')

just for those of you who are curious. thanks ollie!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...