记录数量不一致 [英] Discerpancy in number of records

问题描述

我正在使用Access 2000.我有一个简单的CD集合数据库，

只有三个字段，艺术家，专辑标题和音乐类型。今天用几张新CD来更新

，我注意到如果我按字母顺序排序

艺术家它有387条记录，但如果我按照专辑排序标题显示393条记录。

知道为什么会这样吗？而且我知道至少有两个标题，当我在艺术家排序下寻找它们时，它们不会显示出来。显然还有更多的b
缺失。谢谢。

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.

推荐答案

< rf **** @ optonline.netwrote in message

新闻：kr ******************************** @ 4ax.com ...

<rf****@optonline.netwrote in message
news:kr********************************@4ax.com...

我正在使用Access 2000.我有一个简单的我的CD收藏数据库，

with

只有三个领域，艺术家，专辑标题和音乐类型。虽然今天要用几张新CD来更新

，我注意到如果按字母顺序排序

by

艺术家它拥有387条记录但是如果我按专辑标题排序它会显示393

记录。

任何想法为什么会这样？而且我知道至少有两个标题，当我在艺术家排序下寻找它们时，不会显示

。显然有一些

更多

缺失。谢谢。

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是不支持，但Service Pack和其他更新仍然可用
仍然可用 - 我的第一步是要看帮助关于微软

Access 2000"并确保它处于SP3级别;然后转到

Microsoft站点进行Office更新，看看是否有更新。


如果你是最新的，或者你还是带上你的

访问最新版本之后，进入查询生成器，在

工具栏的最左边部分，单击下拉列表，选择SQL视图，复制SQL对于这两个查询，

将其粘贴到对此主题的回复中，也许有人会有一个很好的建议。


Larry Linson

Access 2000 is "out of support", 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

2008年5月12日星期一21:02:14 GMT，Larry Linson < bo ***** @ localhost.notwrote：

On Mon, 12 May 2008 21:02:14 GMT, "Larry Linson" <bo*****@localhost.notwrote:

>
< rf **** @ optonline.netwrote in message
news：kr********************************@4ax.com ..

>
<rf****@optonline.netwrote in message
news:kr********************************@4ax.com.. .

>我正在使用Access 2000.我有一个简单的CD集合数据库，
只有三个字段，艺术家，专辑标题和音乐类型。虽然今天要用几张新CD来更新
，我注意到如果我按字母顺序排序
由艺术家创作它有387条记录，但如果我按照专辑排序标题显示393
记录。
任何想法为什么会这样？而且我知道至少有两个标题在我按照艺术家类别查找时不会显示
。显然有一些更多的缺失。谢谢。

>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是不支持，但Service Pack和其他更新仍然可用 - 我的第一步是查看帮助|关于微软
Access 2000并确保它处于SP3级别;然后转到Microsoft网站进行Office更新，看看是否有更新。

如果您是最新的，或者如果您在使用
访问最新版本，进入查询生成器，在
工具栏的最左侧部分，单击下拉列表，选择SQL视图，复制两个查询的SQL，将其粘贴到对此线程的响应中，也许有人会有一个很好的建议。


Larry Linson

Access 2000 is "out of support", 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

谢谢。我检查了帮助关于并且什么也没看到提到SP3或

其他任何东西。只是版本号，版权信息和产品ID号。 Am

我在正确的位置寻找？

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?

2008年5月12日星期一21:02:14 GMT， Larry Linson < bo ***** @ localhost.notwrote：

On Mon, 12 May 2008 21:02:14 GMT, "Larry Linson" <bo*****@localhost.notwrote:

>
< rf **** @ optonline.netwrote in message
news：kr********************************@4ax.com ..

>
<rf****@optonline.netwrote in message
news:kr********************************@4ax.com.. .

>我正在使用Access 2000.我有一个简单的CD集合数据库，
只有三个字段，艺术家，专辑标题和音乐类型。虽然今天要用几张新CD来更新
，我注意到如果我按字母顺序排序
由艺术家创作它有387条记录，但如果我按照专辑排序标题显示393
记录。
任何想法为什么会这样？而且我知道至少有两个标题在我按照艺术家类别查找时不会显示
。显然有一些更多的缺失。谢谢。

>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是不支持，但Service Pack和其他更新仍然可用 - 我的第一步是查看帮助|关于微软
Access 2000并确保它处于SP3级别;然后转到Microsoft网站进行Office更新，看看是否有更新。

如果您是最新的，或者如果您在使用
访问最新版本，进入查询生成器，在
工具栏的最左侧部分，单击下拉列表，选择SQL视图，复制两个查询的SQL，将其粘贴到对此线程的响应中，也许有人会有一个很好的建议。


Larry Linson

Access 2000 is "out of support", 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

好​​的，我去了微软的网站，并首先下载了SP1a，因为我显然已经安装了没有SP的
。我安装了然后安装了SP3所以所有都是最新的（

SP版本现在出现在帮助|关于），但是

记录的数量问题仍然存在存在。现在我无法在任何下拉菜单或工具栏上找到任何查询生成器。我在帮助中查找了它，它告诉我在设计视图中打开一个

文档。我试过了，并且发出一个警告，我不能这样做

，因为浏览器中的安全设置设置得太高而且降低它或者

看到我的系统管理员。我是管理员。这是我的家用电脑。

他们在谈论什么浏览器？我只知道网络浏览器，即
Internet Explorer。这与Access有什么关系？我很困惑。

底线是我无法弄清楚为什么，有一种我得到一些

记录和另一种，我得到一个不同的号码。

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

这篇关于记录数量不一致的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！