AnsweredAssumed Answered

Vessel tracking, reporting and inventory setup! No idea!

Question asked by SamGray on Mar 21, 2011
Latest reply on Mar 31, 2011 by philmodjunk

Title

Vessel tracking, reporting and inventory setup! No idea!

Post

Hello all,

Sorry to have absolutely no idea at all... but I'm trying to set up a database, with daily, weekly and monthly input of different information, regarding a ship's position, its environment, a report of it's catch, sorted by species, and weekly/monthly reports of inventory levels (fuel, bait, etc..)

I can set this up fine as a single record for each ship... but I need to be able to keep the information of each individual daily/weekly/etc. update... and then combine totals of this in reports...

HELP!!!

My main issue obviously is how to make a single record on one table that is effectively a total of every record on a separate table...

Outcomes