RE: Rusty on Access syntax

2004-09-03 Thread Angel Stewart
You're welcome! :) *big grin* -Gel -Original Message- From: John Stanley   Angel, thanks. I was avoiding that Query builder for some reason, and it turns out to be pretty easy to use. So anyway, I got it working. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

RE: Rusty on Access syntax

2004-09-03 Thread John Stanley
Angel, thanks. I was avoiding that Query builder for some reason, and it turns out to be pretty easy to use. So anyway, I got it working. -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 2:14 PM To: CF-Community Subject: RE: Rusty on Access

RE: Rusty on Access syntax

2004-09-03 Thread Angel Stewart
Use Access Query Builder to create the query and then go to the SQL View. -Gel -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Okay, I have to do some work in Access and I cant figuire out the problem with this query, besides the fact that is doesnt run. I'm pretty su

Rusty on Access syntax

2004-09-03 Thread John Stanley
Okay, I have to do some work in Access and I cant figuire out the problem with this query, besides the fact that is doesnt run. I'm pretty sure I just have the syntax wrong, but cant find a site with a spec on Access join syntax. select p1.name, p2.name as father, p3.name as mother, p4.name as g