matt_v Posted September 28, 2007 Share Posted September 28, 2007 Table 1 is an item inventory Table 2 is a record of transfers to another department I have a calculation field that totals the amount of product transfered. I'm in the process of doing a summary view (of table 1 items) that I would like to have display the product transfered in a particular date range. I've got a script that will search table 2 based on the date range, but it does not restrict the records displayed in the summary view. I'm thinking that the solution may be in the calculation field, but I can't find a function that would just sum the found fields. Thanks, Matt Link to comment Share on other sites More sharing options...
Søren Dyhr Posted September 29, 2007 Share Posted September 29, 2007 I've got a script that will search table 2 based on the date range, but it does not restrict the records displayed in the summary view. Well it should do, provided you sort and then turn into preview in a suitable layout??? --sd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6145 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