ContributionsMost RecentMost LikesSolutionsRe: Track Active Employees by DayThank you for the quick reply. I'm looking for total # of unique employees in a given year. The history table doesn't have employee names. It just has 1 record per day with the # of active employees. ------------------------------ Mary Gaughan ------------------------------ Re: Track Active Employees by DayThis worked! Thanks so much, Mark! I now have headcount by any given day, but do you happen to know of a way to track cumulative employees by year? I could have 80 employees on any given day, but the cumulative yearly total employed most often lands around 100. My set up is an Employees table with basic info like name then a second table for Positions. The positions have start and end dates. These two tables are connected via a relationship. ------------------------------ Mary Gaughan ------------------------------ Re: Track Active Employees by DayThanks, Sharon! This worked great. Do you happen to know if there is any other way to do this through calculations instead of snapshots? Just thinking (1) the snapshot table will have a ton of records and (2) if someone is unable to enter a new hire or departure in time, it may miss the snapshot. No worries if not.. this solution is great and I really appreciate the help! -Mary ------------------------------ Mary Gaughan ------------------------------ Track Active Employees by DayI have a table which lists employees and a formula field which determines if they are currently active based on their start and end date. Any suggestions on how I could generate a table or report that keeps record of the number of active employees each day? Thanks! ------------------------------ Mary Gaughan ------------------------------