[AccessD] Query giving different results each time

A phone number does not always have to be created as a Primary...so there 
won't always be the same number of records for each number...if there are 3 
numbers...and 2 of them toggle back and forth as the primary...with each 
toggle of the primary setting...the app will write a record for each of the 
numbers affected.

This thing writes a record evertime the wind blows.

I actually found a table that gets 6 records everytime a reminder is 
set...but 5 of them are blank 99.9% of the time.

Thanks, for the feedback...

Mark


>From: Gustav Brock <gustav at cactus.dk>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Query giving different results each time
>Date: Wed, 28 Jul 2004 20:50:32 +0200
>
>Hi Mark
>
>Don't you miss the initial record here?
>The first must be a Y record. And all numbers except the currently
>used must be represented an equal number of times.
>
>And you have four records for 22-Jan-04 but three Ns and only one Y
>and three phone numbers - something must be missing?
>
> > bo_id   profile_cm_seq  primary_ind     effdt  phone
> > 10      84562                     Y 14-Jul-04  555/481-5549
> > 10      2588                      Y 22-Nov-03  555/363-2290
> > 10      2588                      N 22-Jan-04  555/363-2290
> > 10      4444444                   N 22-Nov-03  555/796-3360
> > 10      4444444                   N 22-Jan-04  555/796-3360
> > 10      4444444                   N 14-Jul-04  555/796-3360
> > 10      65542                     Y 22-Jan-04  555/363-4490
> > 10      84562                     N 22-Jan-04  555/781-5549
>
>Rearranged:
>
> > bo_id   profile_cm_seq  primary_ind     effdt  phone
> > 10      4444444                   N 22-Nov-03  555/796-3360
> > 10      2588                      Y 22-Nov-03  555/363-2290
> > 10      2588                      N 22-Jan-04  555/363-2290
> > 10      65542                     Y 22-Jan-04  555/363-4490
> > 10      84562                     N 22-Jan-04  555/781-5549
> > 10      4444444                   N 22-Jan-04  555/796-3360
> > 10      4444444                   N 14-Jul-04  555/796-3360
> > 10      84562                     Y 14-Jul-04  555/481-5549
>
>/gustav
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/