Craig Anderson Posted December 9, 2020 Share Posted December 9, 2020 I preface this with the comment that I know little about managing databases. I have a custom field that I use to identify what box each book is in. I want to run a report that shows me 1) how may books are in each box 2) what books are in each box Is that possible? Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted December 9, 2020 Share Posted December 9, 2020 I can think of one way to get you something like you want but you need to run this once for each box you have. Use Find on the field with your Box number is the first box (ex. Box_number IS 1) Select all the rows (CTRL+A), then Right-Click to bring up the pop-up menu and select Quick Report (or use F7). This will bet you a list of all the Titles/Item #'s in that box and at the bottom the Total of the Items. Run again for Box_Number 2, then 3, 3, 5... until you reach the last box. Link to comment Share on other sites More sharing options...
Recommended Posts
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