“是空还是不空？就是那个问题... [英] "Is Null or Is Not Null? That is the question...

问题描述

首先，嘿那里:)。


我一直在读Access上的几个主题和诸如此类的东西，但我似乎无法找到我需要的答案。 />

首先，我是计算机的新手，所以请耐心等待。

我正在使用Access 2003，目前正在创建数据库以便从我们当前的数据库，方法转移我们的信息。


我目前自学成才;书籍，指南等......我尽可能多地喂食和吸收，但我现在被困住了，所以我想我会问这里，看看我是否能找到一个可以帮助我的技术人员;-)。


我已经创建了表格，查询和表单。我已经从Approach to Access中导出了一些信息，因此我可以使用一些东西。我想弄清楚我的过滤和搜索可能性，但当我点击我要过滤的字段并点击向下箭头时，它给了我两个选项..Is Null和不是空......


现在......那就是我被困的地方现在，它可能是非常简单的东西，但我宁愿问，我在Office 2003中看到傻瓜，我应该看到一些选项，但它并没有说明如何做以上情况。尝试在google上做一些搜索但是没什么帮助。


我从这里采取什么步骤？我是否错过了沿途的一步，或者我应该选择其中一个并保存？


任何建议都会受到赞赏，希望很快能听到任何人的意见！

先谢谢。

First of, Hey there :).

I''ve been reading a few threads on Access and whatnot, but I cant seem to find the answer I need.

First off, I am a newbie when it comes to computers, so bear with me please.
I am using Access 2003, currently creating a database in order to tranfer our information from our current database, Approach.

I am currently self-taught; books, guides, etc... feeding and absorbing as much as I can but I am stuck now, so I figured I''d ask here and see if I can find myself a tech guy who can help me out ;-).

I have gone through creating tables, queries and forms. I already exported some of information from Approach to Access, so I could have something to work with. Im trying to figure out my "filter and search" possibilities, but when I click on the field that I want to filter and click on the downward-pointing arrow, it gives me two options.. "Is Null" and "Is Not Null"...

Now... thats where I am "stuck" now, it may be something very simple but I rather ask, I saw in Office 2003 for Dummies, that I should see some options, but it doesnt say what to do in case of the above. Tried doing some searchs on google and whatnot but didnt help much.

What steps do I take from here? Did I miss a step along the way or am I supposed to pick one of them and save?

Any advice would be appreciated, hope to hear from anyone soon!
Thanks in Advance.

推荐答案

我无法重现你的问题。

你是如何到达Null on Null这些选项的地方？


我怀疑它们只是预定义的opotions而你可以添加其他的（如'Blah Blah *''）。

I can''t reproduce your problem.
How are you getting to the place where you have these options of Null on Not Null?

I suspect that they are just pre-defined opotions and you can add others (Like ''Blah Blah *'') if you want to.

我假设你在谈论过滤数据表形式。

表单是绑定到表还是查询？

在设计视图中，您尝试过滤的字段的文本框绑定到表或查询中的字段？


听起来你试图过滤一个不受任何字段约束的控件，所以唯一可用的选择是null并且不为null。

I assume you are talking about filtering datasheet forms.
Is the form bound to a table or query?
In design view is the textbox of the field you are trying to filter on bound to a field in a table or query?

It sounds like you are trying to filter on a control that isn''t bound to any field so the only choices available are is null and is not null.

首先，嘿那里:)。


我一直在读书Access上的几个主题和诸如此类的东西，但我似乎无法找到我需要的答案。


首先，我是计算机的新手，所以请耐心等待。

我正在使用Access 2003，目前正在创建一个数据库，以便从我们当前的数据库中传输我们的信息，方法。


我目前自学成才;书籍，指南等......我尽可能多地喂食和吸收，但我现在被困住了，所以我想我会问这里，看看我是否能找到一个可以帮助我的技术人员;-)。


我已经创建了表格，查询和表单。我已经从Approach to Access中导出了一些信息，因此我可以使用一些东西。我想弄清楚我的过滤和搜索可能性，但当我点击我要过滤的字段并点击向下箭头时，它给了我两个选项..Is Null和不是空......


现在......那就是我被困的地方现在，它可能是非常简单的东西，但我宁愿问，我在Office 2003中看到傻瓜，我应该看到一些选项，但它并没有说明如何做以上情况。尝试在google上做一些搜索但是没什么帮助。


我从这里采取什么步骤？我是否错过了沿途的一步，或者我应该选择其中一个并保存？


任何建议都会受到赞赏，希望很快能听到任何人的意见！

先谢谢。

First of, Hey there :).

I''ve been reading a few threads on Access and whatnot, but I cant seem to find the answer I need.

First off, I am a newbie when it comes to computers, so bear with me please.
I am using Access 2003, currently creating a database in order to tranfer our information from our current database, Approach.

I am currently self-taught; books, guides, etc... feeding and absorbing as much as I can but I am stuck now, so I figured I''d ask here and see if I can find myself a tech guy who can help me out ;-).

I have gone through creating tables, queries and forms. I already exported some of information from Approach to Access, so I could have something to work with. Im trying to figure out my "filter and search" possibilities, but when I click on the field that I want to filter and click on the downward-pointing arrow, it gives me two options.. "Is Null" and "Is Not Null"...

Now... thats where I am "stuck" now, it may be something very simple but I rather ask, I saw in Office 2003 for Dummies, that I should see some options, but it doesnt say what to do in case of the above. Tried doing some searchs on google and whatnot but didnt help much.

What steps do I take from here? Did I miss a step along the way or am I supposed to pick one of them and save?

Any advice would be appreciated, hope to hear from anyone soon!
Thanks in Advance.

对不起，这对我来说很奇怪，第一次在这类论坛发帖...

我假设你在谈论过滤数据表表格


是的，过滤数据表和表格..

表单是否绑定到表或查询？


如果绑定，则表示已连接或者从表/查询中复制，然后是。我按照指示从表中创建了表单。

在设计视图中，您尝试过滤的字段的文本框绑定到字段在表格或查询中？


如何查看？

你怎么样？你可以选择Null on Null 的地方吗？


好​​的 - 打开表格>选择记录>按表格过滤>点击您要用作过滤器的字段>点击向下箭头>在这里......我应该看到一个下拉列表，实质上，如果我点击字段状态，我应该有一个状态列表...相反，我有两个选项..是否Null不是Null ..


根据我工作的指南，我应该看到一个列表...但我不是因为我卡住了这个原因。
听起来你正试图过滤一个不受任何字段束缚的控件，因此唯一可用的选择是null并且不为空


我也这么认为......任何建议？感谢您的帮助：）

Im sorry, this is strange for me, first time posting in this sort of forum...

I assume you are talking about filtering datasheet forms

Yes, filtering both datasheets and in form..

Is the form bound to a table or query?

If by bound, you mean "connected" or reproduced from a table/query, then yes it is. I created the form from the query which was created from the table, as instructed.

In design view is the textbox of the field you are trying to filter on bound to a field in a table or query?

How do I check that?

How are you getting to the place where you have these options of Null on Not Null?

Okay- Open Form> choose Records> Filter by Form> click on the field you want to use as your filter> click on the downward pointing arrow> and here... is where im supposed to see a pull down list, in essence, if I click on field State, I should have a list of states... instead, I have the two options.. Is Null is not Null..

According to the guides Im working with, I should be seeing a list... but Im not thus the reason Im stuck atm.

It sounds like you are trying to filter on a control that isn''t bound to any field so the only choices available are is null and is not null

I think so too.... any advice? Thanks for the help :)

这篇关于“是空还是不空？就是那个问题...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！