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
>
Okay, I went to Microsoft's site and first downloaded SP1a as I apparently
had
no SP's installed. I installed that then installed SP3 so all is up to
date (the
SP version shows up now in Help | About), but the problem with the number
of
records still exists. Now I can't find Query Builder anywhere in any drop
down
menus or on the tool bar. I looked it up in Help and it tells me to open a
do***ent in Design View. I tried that and get a warning that I can't do
that
because the security setting in my browser is set too high and to lower it
or
see my system administrator. I AM the administrator. This is my home
computer.
What browser are they talking about? I only know about web browsers i.e.
Internet Explorer. What would this have to do with Access? I'm totally
confused.
Bottom line is I just can't figure out why, with one sort I get one number
of
records and with another sort, I get a different number.
|
