On Mon, 12 May 2008 21:02:14 GMT, "Larry Linson" <bouncer@[EMAIL PROTECTED]
>
wrote:
>
><rfdjr1@[EMAIL PROTECTED]
> wrote in message
>news:krah24lbrfi0mo2dj65agmg0s334eps6pm@[EMAIL PROTECTED]
>> I'm using Access 2000. I have a raher simple database of my CD
collection,
>> with
>> just three fields, Artist, Album Title and Type of Music. While going
to
>> update
>> it today with a couple new CD's, I noticed that if I sort
alphabetically
>> by
>> Artist it have 387 records but if I sort by Album Title it shows 393
>> records.
>> Any idea why this would be? And I know of at least two titles that
don't
>> show
>> up when I look for them under the Artist sort. There's obviously a few
>> more
>> missing. Thanks.
>
>Access 2000 is "out of sup****t", but the Service Packs and other updates
are
>still available -- my first step would be to look at "Help | About
Microsoft
>Access 2000" and make certain that it is at the SP3 level; then go to the
>Microsoft site for Office update and see if there are later updates.
>
>If you are up-to-date, or if you still experience this after bringing
your
>Access up to date, go into Query Builder, on the leftmost part of the
>toolbar, click the dropdown, choose SQL view, copy the SQL for both
querys,
>paste it into a response to this thread, and maybe someone will have a
good
>suggestion.
>
> Larry Linson
>
Thanks. I checked "Help | About and see nothing at all mentioning SP3 or
anything else. Just the version number, copyright info and Product ID
number. Am
I looking in the right spot?
|
