bbud Posted August 19, 2011 Posted August 19, 2011 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
comment Posted August 19, 2011 Posted August 19, 2011 You can import a summary field (if that's what you mean by "summed field") just like any other field.
bbud Posted August 19, 2011 Author Posted August 19, 2011 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
comment Posted August 19, 2011 Posted August 19, 2011 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.
Recommended Posts
This topic is 5195 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now