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
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:
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
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
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
5 matches
Mail list logo