ContributionsMost RecentMost LikesSolutionsRe: Formula/RelationshipsThere may be duplicates ------------------------------ Samantha Stanley ------------------------------ Formula/RelationshipsI have 2 tables I am trying to cross reference. Table 1 - Accounts - lets say this table has account names and dates the request was submitted Table 2 - End of Day Report - This report has the account names and dates that were submitted with even more information. I want a formula that will reference table one and match them up based on account name and submitted date. Not sure if it matters - I tried to set up table to table relationships and it seems like I would have to manually match each account up. These reports will be imported daily and can have approx. 600 accounts on them. It would be to time consuming to match each one. ------------------------------ Samantha Stanley ------------------------------ Re: FormulasThat worked, thank you! ------------------------------ Samantha Stanley ------------------------------ FormulasI have a form that shows 3 questions where the answer options are all Yes/No. If the question is answered as "Yes" I want it to be counted as one error, and "No" is equal to no errors. I have a field for "Total # of Errors" and a field for the %. How would I create the formulas to show the total number of errors? ------------------------------ Samantha Stanley ------------------------------