D. 警告——今后的新bie
我的表格有一栏,其内有带有图像的OLE/object格式。
一些牢房有图像,有些没有。
我想计算一栏的图像数目。
我认为,可能要增加一栏,其中将有一个公式,用以检测图像的电池是空的还是满的,然后将表格出口到Excel并计算结果。
我不知道如何用公式打一栏。
或许还有另一种方式要做。
任何帮助都将受到赞赏。
感谢。
D. 警告——今后的新bie
我的表格有一栏,其内有带有图像的OLE/object格式。
一些牢房有图像,有些没有。
我想计算一栏的图像数目。
我认为,可能要增加一栏,其中将有一个公式,用以检测图像的电池是空的还是满的,然后将表格出口到Excel并计算结果。
我不知道如何用公式打一栏。
或许还有另一种方式要做。
任何帮助都将受到赞赏。
感谢。
我认为,这一公式可以发挥作用:
SUM(Iif([image_column] IS NULL, 0, 1))
如果你在问询中有其他领域的话,你必须按其他栏组别。
我这样说了! 我原想,我可以用SQ对一个ACCESS表进行查询。
这一公正的工作
从2011年=1的表格中选取(百分率)
In C#, I know that I can overload the constructor for a class by specifying it in the body of the class: public class MyClass() { public MyClass(String s) { ... } } This overrides the default ...
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 ...
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, ...
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 ...
I m using Application run to call several macros in order like this. Sub Run_All_Macros() Application.Run ("Macro_1") Application.Run ("Macro_1") End Sub When I start Run_All_Macros, all the ...
I m using Microsoft Office 2003 and creating a bunch of template documents to standardize some tasks. I asked this on Superuser.com and got no response so I m thinking it s too program-y and hoping I ...
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 ...
I need to ensure a Macro which works on Visio 2003 doesn t cause problems on lower versions of Visio: specifically because I m writing to a property which doesn t exist on lower versions of Visio. ...