Is there an easy way to import a summed fields data into another db.

For example, I have a summed field that totals the cost of several shipments.

I have another db that uses that summed field, and I would like to pull the summed field from the shipping db into my overall db.

Thanks,

Bob

You can import a summary field (if that's what you mean by "summed field") just like any other field.

Thanks, you are correct, a summary field. Let me correct my question, does you answer change if I say it is a look-up from the target db to the source db that has the summary field, and then pulling the summary field to the target db.

Thanks,

Bob

does you answer change if...

I don't think so (provided I understood your question). You can lookup a summary field value just fine. But my eyebrow is raised regarding the entire method. A summary field has a common value for all records in the table (assuming the source file is closed), and importing it or looking it up at from individual records will result in duplicate values.