Help with exporting records

Discussion created by kjw282 on Sep 8, 2017
Latest reply on Sep 8, 2017 by philmodjunk

I have a database of receipts by vendors.  I copied and adapted this database from a template.  I place an X in a field that designates specific receipts to be selected to pay.  I want to export the receipts that are being paid by a particular vendor to a spreadsheet where I can then use those records in a mail merge document in WORD.  (I already have the script for this to work)  After exporting those specific receipts, I want to create a button that will move the items to a paid table and then delete them from the list of receipts showing for each vendor.  How do I write the script that will take the receipts with an X, copy them to a different "Paid" table and the delete them from the "receipts" table?