Groove Fetish

yah the table name is 'C

here is the whoel statement:

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

FROM ['C]

WHERE (((['C].[Award Date])<='2007') AND ((['C].[End Date])>='2007')) AND (['C][PI-lastname] = 'baptiste' or [PI-lastname] = 'macdermid')

so what happened when I switched to that was that it asked me for start dates parameters and end date parameters and last name parameters. but I thought those parameters were already in the string so shoudln't it have know that I wanted all dates >2007 and all dates ,2007 and macdermid and baptiste??? when I put in the parameters it actually retruned all the records in the database. so that one doesn't seem to work.

all this help is appreciated.

oh the 'C is the name of the table not sure why the ' is there but Acceess renamed it that itself

so statement looks like this now:

WHERE (((['C].[Award Date])<='2007') AND ((['C].[End Date])>='2007')) AND (['C][PI-lastname] = 'baptiste' or [PI-lastname] = 'macdermid')

but its still saying syntax error.

I do not know how to remove the spaces from the field names?? just go into design view and delete them?

ok I added an AND and took out the . but I am still not there:

WHERE (((['C].[Award Date])<="2007") AND ((['C].[End Date])>="2007")) AND (['C][PI-lastname] = 'baptiste' or [PI-lastname] = 'macdermid')

now its saying missing operator

I just took that "." out and its still saying there are characters left after the SQl string

its saying there are characters left after the end of the SQL statement

oh and I know there are records to return on this string so I should get results

here is the SQL string

WHERE (((['C].[Award Date])<="2007") AND ((['C].[End Date])>="2007"));(['C]. [PI-lastname] = 'baptiste' or [PI-lastname] = 'macdermid')

something is wrong with it but I can figure out what??

thanks for the help!

no sorry its telling me that there is a syntax problem with a comma??

i'm using this

=('macdermid','baptiste') but its not returning anything???

Happy Birthday dude

awesome reference dude

hi all...I tend not to post too often but I'm having troubles learning access and want to see if anyone can help me out.

I am trying to get a query to return some data and I can seem to get it to do what I want. I have a last name field and I want the datasbe to return to me any records that have certain names in them. But it is not just an equals to statement it should be a equals to or equals to or equals to....know what I mean??

so example. I have a record that says macdermid and a record that says baptiste and a record that says bosch. I want the baptiste records and macdermid records but not the bosch records. how does that statement look like.

this might be a really rudimentary question but I'm trying to teach myself access and its an uphill battle so far.

Thanks in advance for any help.

$46 s face

face if you can handle it but less if no one is really interested. I just can't go and don't want to waste the ticket.

wow- I wonder if that would work...seems plausible but I must admit not sure about getting rid of the hay...but maybe the burning of the oil would be the least harmful then it sitting in our gulf waters..

cool eric- I didn't know you were going...we are too! We are going to be Luke and Leia and Zack (although he will be at grandmas and grandpas) will be Yoda!

What are some of your costumes??

http://www.dampkring.nl/

The Dampkring is teh best in my 1999 memory. Hit up the Melkweg and Patridiso if possible and maybe the zoo.

Get the get lost guide to asterdam and look up squat restaurants.

Those are my best recommendations.

http://ca.news.yahoo.com/s/capress/090302/world/oddity_marijuana_cat

what a freak!

people are friggin' crazy!

Whoa dude- Major healing vibes to you!!!

((((((((((((((Vibes))))))))))))))))))))

this is a good romantic one...if you've never picked up any of Gilles Peterson's various collection- he has a great ear and this stuff is awesome.

one of the best 80's album... Dr. Heckle and Mr. Jive!!

best vinyl ever- best groovy album ever- Denson Rules!! FYI- never knew this but in the movie coming to America- Denson played the lead in the Sexual Chocolate band.- Made me want to go rent the movie agian just to see that part!