Summary Field Data

Question

I have created a summary report that shows the number of records that I have for each item. I would like to take the number from the far right (the number of inventory items) and display on another table.

The closest I have gotten is having a report link to all the records of that particular item number. I don't care if that link works or not, I just need to be able to see the number of inventory I have.

------------------------------Katlyn Allen------------------------------

markshnier__you · Answer

Katlyn,Do you have a relationship where One Item Number has Many Inventory Records? If so, what you want to do is to make a summary field on that Relationship to total up the total qty or the total #&nbsp;of Inventory records and put that on your Item Number Master form.To make a Summary field you go into the relationship and use the link on the left side to Add Summary field.&nbsp;&nbsp;&nbsp;​​------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

katlyncowley · Answer

That is exactly what I needed! Thank you!------------------------------Katlyn Allen------------------------------

markshnier__you · Answer

Hey, sometimes you get lucky and what you want is easy. With Quick Base it's often easy to get lucky.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Forum Discussion

Summary Field Data

Related Content

Summary Reports

If currency(summary field) is blank formula help

Missing Records/Data Issue

Extrapolating nuanced data

Default column widths on embedded reports obscuring data