Nz(DCount

[Little Penny]

What is the proper syntax of this dcount statement

=Nz(DCount("OperatingSystem","Workstations")","("OperatingSystem = "Windows 2000","),0)

I want it to count all the Operating System in the Workstation table that are equal Windows 2000

If I can do this a and want to add a third criteria for instance PhysicalMemory less than 1024k
How would I do that?




Thanks

 

[George Nicholson]

DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows
2000'")

DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows
2000' AND [PhysicalMemory] <1024")

AFAIK, the NZ function provides no useful purpose when using DCount,
although it does when using DLookup.

HTH,

 

[Little Penny]

I can't get this to work

I put this in the control source of a test box

DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows 2000'")


I get this #Name? in the box

 

[George Nicholson]

Preceded by an equal sign? OperatingSystem is the correct spelling of a
field in a table named Workstations?

--
George Nicholson

Remove 'Junk' from return address.

I can't get this to work

I put this in the control source of a test box

DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows
2000'")


I get this #Name? in the box

DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows
2000'")

DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows
2000' AND [PhysicalMemory] <1024")

AFAIK, the NZ function provides no useful purpose when using DCount,
although it does when using DLookup.

HTH,

 

[Eric D via AccessMonster.com]

Put the "=" back in the front of the statement.

I can't get this to work

I put this in the control source of a test box

DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows 2000'")

I get this #Name? in the box

DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows
2000'")

[quoted text clipped - 6 lines]

HTH,

 

[Little Penny]

=DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows 2000'")

Eric I get an error when I do this

Put the "=" back in the front of the statement.

I can't get this to work

I put this in the control source of a test box

DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows 2000'")

I get this #Name? in the box

DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows
2000'")

[quoted text clipped - 6 lines]

HTH,

 

[Eric D via AccessMonster.com]

Can you provide additional information?
Are you trying to use the DCount function in a macro, in code or form, or are
you trying to use the DCount function within a query?

If you are trying to use DCount in a query, you should switch to the Count
function using Totals.
If macro or form, then DCount is OK.

You must get the syntax of the statement correct in order for it to work
properly. This is not always easy, at first.
=DCount("[fieldyouwanttocount]", "Tablethatcontainsfieldyouwanttocount", "
[FieldToFilter] = ' FilterOnThis ' " )

To see if you have the first part correct, try:
=DCount("[OperatingSystem]", "Workstations")

This should give you the total number of records in you table - Workstations.
If you get the desired results here, you're better than half way home. If not,
you need to provide further information in order for someone to provide
addtional help. If this shortened statement works, add the Where clause. I
added spaces to this section so that you could see the single/double quotes
properly, you would not include these spaces.

I tested all of the above using a form and a textbox. If this is NOT what you
are doing, please clarify.

=DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows 2000'")

Eric I get an error when I do this

Put the "=" back in the front of the statement.

[quoted text clipped - 11 lines]

 

[Eric D via AccessMonster.com]

Another item:

Is [OperatingSystem] the best field for you to count? Could it ever be null?
If so, you won't get the corrrect count.
You can simplify the statement by the following:

=DCount( " * ", "YourTable", "[FieldToFilter] = ' FilterGoesHere ' " )
(again, I added spaces in " * " - for clarity. You shouldn't)

Hope that helps!

=DCount("[OperatingSystem]","Workstations","[OperatingSystem] = 'Windows 2000'")

Eric I get an error when I do this

Put the "=" back in the front of the statement.

[quoted text clipped - 11 lines]