<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
|
