Assign recordcount to variable

[Guest]

I have a query with one output field which counts records that meet certain
criteria in a table.

How can I assign this value to a variable in a module.

Thanks in advance.

 

[Guest]

Try

VariableName = DlookUp("FieldName","QueryName")

 

[David C. Holley]

Why not just use DCount() as in lngRecordCount = DCount([parameters])