Dlookup

[Guest]

can I use dlookup to retrieve a value from a table that is not related to the
table the form is based on to use in a calculation?

Calculated field : =Sum(dlookup(table.field)

 

[fredg]

can I use dlookup to retrieve a value from a table that is not related to the
table the form is based on to use in a calculation?

Calculated field : =Sum(dlookup(table.field)

You can most likely use DSum().
You'll need to give us more information if you want a more specific
answer than the generic example below
..
=DSum("[FieldName]","TableName")