View My Drafts
Hi! Thanks in advance for your help! I have been making do with a query, but it just occurred to me I wonder if there is a better way.Each month I pull a refreshable quick query for COGS from the inventory item table to run some calculations on cost and quantity by product class. Currently, I need to remember that PTDCOGS00 and PTDQtySls00 is actually for January, PTDCOGS01 is Feb, and so on. That's no big deal. But my question is...at year end I have to sum all of the fields together to get a total. Is there a total already in the system I could use?