Re: angry query with sharp teeth : avoid!!!

2000-10-26 Thread Deanna L. Schneider
Access syntax is pretty funky. The easiest thing I've always found is to open the access database and use the native query builder to create your joins. When you're using multiple tables, you need to nest your joins. Take a look at this example from a query I did: FROM (party INNER JOIN (race

RE: angry query with sharp teeth : avoid!!!

2000-10-26 Thread Gary Davidson
lto:[EMAIL PROTECTED]] Sent: Thursday, October 26, 2000 12:06 AM To: CF-Talk Subject: OT: angry query with sharp teeth : avoid!!! bite! bite! Grrr! First thanks again to those that helped me yesterday with a similar query. I figured out how to run this query on a table of messages, also pulling from

OT: angry query with sharp teeth : avoid!!!

2000-10-25 Thread Russell Jones
bite! bite! Grrr! First thanks again to those that helped me yesterday with a similar query. I figured out how to run this query on a table of messages, also pulling from the users table where appropriate. (for an Access DB by the way, query pasted below for reference) ... (The secret was a