English 中文(简体)
2003年MS-ACCESS一栏数字图像
原标题:Counting images in an MS-ACCESS 2003 column

D. 警告——今后的新bie

我的表格有一栏,其内有带有图像的OLE/object格式。

一些牢房有图像,有些没有。

我想计算一栏的图像数目。

我认为,可能要增加一栏,其中将有一个公式,用以检测图像的电池是空的还是满的,然后将表格出口到Excel并计算结果。

我不知道如何用公式打一栏。

或许还有另一种方式要做。

任何帮助都将受到赞赏。

感谢。

问题回答

我认为,这一公式可以发挥作用:

SUM(Iif([image_column] IS NULL, 0, 1))

如果你在问询中有其他领域的话,你必须按其他栏组别。

我这样说了! 我原想,我可以用SQ对一个ACCESS表进行查询。

这一公正的工作

从2011年=1的表格中选取(百分率)





相关问题
Handling no results for docmd.applyfilter

I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the ...

Outlook 2007 CommandBarControl.Execute won t work

I recently switched to Outlook 2007 and noticed that my VBA-macros won t work. I use the following code to open a new appointment-item (and fill it automatically). It worked perfect in Outlook 2003, ...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

MS Access: list macro from VBA

I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by ...

热门标签