Howdy Folks,<BR><BR>I have an Access database that contains water chemistry analyses. Some of the results are large numbers (10,000+) and some are smaller (0.034). <BR><BR>When running a query or a ...

I do not believe Jet (the database engine Access uses) supports table-level triggers, so you'll need to use a macro or VBA code in a form to trigger the extra record.