[AccessD] Upsizing (was: Desperately Seeking!)

Hi Arthur

Phew! I was beginning to wonder if one of your senior moments had been
extended beyond a point of no return.

/gustav


> Oops. In my needless haste, I think I wrote it incorrectly. Should have
> been:

> Faculty_ID = @Faculty_ID AND School_ID = @School_ID
> OR
> Faculty_ID = @Faculty_ID AND @School_ID = 'All'
> OR
> @Faculty_ID = 'All'

> This is intended to account for three cases, summarized in the following
> possible arguments:

> @Faculty_ID = 'All' and @School_ID is 'All' - show everything
> @Faculty_ID = "FB" and @School_ID = 'All' - show all faculty of business
> schools
> Faculty_ID = "FB" and School_ID = 'BM' - show only the business management
> school in the faculty of business

> I have no emotional investment in three cases. If it can be done in two I'm
> happy to go revise.

> A.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: May 4, 2003 1:27 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Upsizing (was: Desperately Seeking!)


> Hi Arthur

> Hmm - are we on the same channel? Over.

> I just can't see why the second case here:

>>         Faculty_ID = @Faculty_ID AND School_ID = @School_ID
>>         OR
>>         Faculty_ID = @Faculty_ID
>>         OR
>>         @Faculty_ID = 'All'

> will NOT return True for any record of a given Faculty_ID no matter what
> School_ID you pass?