DCount help

[McArthurGDM]

I can't seem to get my dcount function to work properly...

I have a Table "StatusT" and a field within StatusT called "Metric". All that I want to do is count the number of records that contain a certain metric.

I figured I would do,



DCount(StatusT!Metric, StatusT, Metric = "Whatever")

but this does not work.

Any suggestions?

[pbaldy]

This should get you started:

DLookup Usage Samples

[McArthurGDM]

Thanks,

That actually worked for the DCount. I didn't realize that there were " ' " quotes that you needed to put into the mix, that stuff is confusing!

Thank you, though.

[pbaldy]

No problem.

[Missinglinq]

That actually worked for the DCount

FYI, the same syntax works for most Criteria of Domain Functions(DCount, DLookup, DSum, etc.) as well as for the Where Conditions in things like

DoCmd.OpenForm(FormName, View, FilterName, WhereCondition, DataMode, WindowMode, OpenArgs)

and in working directly with Recordsets.

Linq ;0)>

[McArthurGDM]

Say I want to do a DLookup on a field "Status" from the table "StatusT"

But then set the criteria to look on the field "ID1" where

ID1 = [Forms]![MainNavigation]![NavigationSubform].[Form]![EditMetric].[Form]![EMMetricID].Str(1)
Or
ID1 = [Forms]![MainNavigation]![NavigationSubform].[Form]![EditMetric].[Form]![EMMetricID].Str(2)
Or
ID1 = ... So on
.
.
.

So, as you can see, the DLookup references a form, but then then is extended upon by a "." and Str(i) for some variable Str that is from a string array.

I can't seem to get the syntax write on this one...it's irritating! How would I write this?

[June7]

Don't like and don't use navigation form/control. Review https://www.accessforums.net/forms/t...orm-32053.html