点还是一声巨响？ [英] Dot or a bang?
问题描述
？DCount（" [tblCorrespondence]！[VehicleJobID]"，" qryAOLsNeed2Print"）
- 或者 -
？DCount（" [tblCorrespondence] 。[VehicleJobID]"，" qryAOLsNeed2Print"）
这两种语法都为我返回了正确的答案。但是我想知道，由于某种原因，一个人是否比另一个人更合适。我正在使用A97。
?DCount("[tblCorrespondence]![VehicleJobID]", "qryAOLsNeed2Print")
- OR -
?DCount("[tblCorrespondence].[VehicleJobID]", "qryAOLsNeed2Print")
Both syntaxes return the correct answer for me. But I''m wondering if
one is more suitable than the other for some reason. I''m using A97.
推荐答案
MLH< CR ** @ NorthState.net>写在
新闻：3p ******************************** @ 4ax.com：
MLH <CR**@NorthState.net> wrote in
news:3p********************************@4ax.com:
？DCount（" [tblCorrespondence]！[VehicleJobID]"，
" qryAOLsNeed2Print"）
- 或 -
？DCount（ [tblCorrespondence]。[VehicleJobID]"，
" qryAOLsNeed2Print"）
两种语法都为我返回了正确的答案。但是我想知道一个人是否比其他人更适合某些原因。我正在使用A97。
?DCount("[tblCorrespondence]![VehicleJobID]",
"qryAOLsNeed2Print")
- OR -
?DCount("[tblCorrespondence].[VehicleJobID]",
"qryAOLsNeed2Print")
Both syntaxes return the correct answer for me. But I''m
wondering if one is more suitable than the other for some
reason. I''m using A97.
爆炸是语法上正确的方式。在大多数情况下，Access允许几个
语法错误。您必须使用bang将
引用到记录集DAOrs.LastName中的字段名称将返回
错误，DAOrs！Lastname将返回该字段的值。
就个人而言，我倾向于更多地考虑那些说这不是正确的方法吗？的人。那些会咆哮的艾？这个
rite？" :-)
-
Bob Quintal
PA是我改变了我的电子邮件地址。
the bang is the syntactically correct way. Access allows several
errors of syntax, most of the time. You must use a bang to refer
to a field name in a recordset DAOrs.LastName will return an
error, DAOrs!Lastname will return the value of that field.
Personally, I tend to think more highly of people who say, "Is
this not the correct method?" than those would growl "Ai''nt this
rite?" :-)
--
Bob Quintal
PA is y I''ve altered my email address.
< snip>
<snip>
爆炸是语法正确的方式。在大多数情况下，Access允许几种语法错误。你必须使用bang来将
引用到记录集DAOrs.LastName中的字段名称将返回
错误，DAOrs！Lastname将返回该字段的值。
很多thx。我想我会坚持语法正确的方式。
就个人而言，我倾向于更多地考虑那些说这不是正确的方法吗？的人。那些会咆哮的艾？这个
仪式？ ： - ）
the bang is the syntactically correct way. Access allows several
errors of syntax, most of the time. You must use a bang to refer
to a field name in a recordset DAOrs.LastName will return an
error, DAOrs!Lastname will return the value of that field. Many thx. I think I''ll stick with the syntactically correct way.
Personally, I tend to think more highly of people who say, "Is
this not the correct method?" than those would growl "Ai''nt this
rite?" :-)
我很高兴我没有咆哮。
I''m glad I didn''t growl.
点是语法正确的方式。在大多数情况下，Access允许几种
语法变体。但根据定义，你应该使用一个点来引用SQL中的字段名称，你也可以使用它来接受它。
习惯它。
在Access和DAO中，TblName！FieldName将返回相同的值，
但如果您在设计视图中打开查询，则访问将显示它
as Expr1：TblName！FieldName。也就是说，Access了解你想要的是什么，但它被解释为一个表达式，而不是普通的SQL，而不是
。
（大卫）
PS：就个人而言，我倾向于更多地考虑那些说，
这是机器：我接受它的行为不符合道德标准
确定
MLH" < CR ** @ NorthState.net>在消息中写道
新闻：3p ******************************** @ 4ax.com ...
The dot is the syntactically correct way. Access allows several
syntax variations, most of the time. But by definition you should
use a dot to refer to a field name in SQL, and you might as well
get used to it.
In Access and DAO, TblName!FieldName will return the same value,
but if you open the query in design view, access will display it
as "Expr1: TblName!FieldName". That is, Access understands what
you want, but it''s been interpreted as an expression, rather than
as ordinary SQL.
(david)
PS: Personally, I tend to think more highly of people who say,
"It''s a machine: I accept that it''s behaviour is not morally
determined"
"MLH" <CR**@NorthState.net> wrote in message
news:3p********************************@4ax.com...
？DCount（" [tblCorrespondence]！[VehicleJobID]"，qryAOLsNeed2Print）
- 或 -
？DCount（" [tblCorrespondence] 。[VehicleJobID]"，" qryAOLsNeed2Print"）
两种语法都为我返回了正确的答案。但是我想知道一个人是否因某种原因比另一个更合适。我正在使用A97。
?DCount("[tblCorrespondence]![VehicleJobID]", "qryAOLsNeed2Print")
- OR -
?DCount("[tblCorrespondence].[VehicleJobID]", "qryAOLsNeed2Print")
Both syntaxes return the correct answer for me. But I''m wondering if
one is more suitable than the other for some reason. I''m using A97.
这篇关于点还是一声巨响？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
