apologies...query display balled up

2002-10-18 Thread Tim Laureska
Man.. I apologize for how the first message came across formatted weird.please let me try again: I have an event calendar access database with two tables (one called category with two fields: cat_no and descr.. the other table is called events with many fields including two called category and

Re: apologies...query display balled up

2002-10-18 Thread Robert Polickoski
Tim, Use the keyword DISTINCT. I am guessing that because record #128 passes both tests, it is getting two result rows. I am not certain, but I think it will do the trick. Take care, -- Original Message -- From: Tim Laureska [EMAIL PROTECTED] Reply-To:

RE: apologies...query display balled up

2002-10-18 Thread Andy Ewings
display balled up Tim, Use the keyword DISTINCT. I am guessing that because record #128 passes both tests, it is getting two result rows. I am not certain, but I think it will do the trick. Take care, -- Original Message -- From: Tim Laureska [EMAIL

RE: apologies...query display balled up

2002-10-18 Thread Tim Laureska
Andy .. using the ORDER BY event_no works, but can you help me understand why that eliminates the duplicates? -Original Message- From: Andy Ewings [mailto:andy.e;thoughtbubble.net] Sent: Friday, October 18, 2002 11:56 AM To: CF-Talk Subject: RE: apologies...query display balled up I

RE: apologies...query display balled up

2002-10-18 Thread Adrian Lynch
balled up Andy .. using the ORDER BY event_no works, but can you help me understand why that eliminates the duplicates? -Original Message- From: Andy Ewings [mailto:andy.e;thoughtbubble.net] Sent: Friday, October 18, 2002 11:56 AM To: CF-Talk Subject: RE: apologies...query display balled