Hello,
I Have a data base with three tables for tracking bills.
Companies:
Accounts:
Payments:
This is to track 30 or so recurring monthly bills for our company. What I was wondering is if their is an easy method to move payments from the previous month to a different table. Or view payments by current month only. Maybe a macro or a query. I know I could once a month go in and create a query to do this each month but I will be going to basic training in April and The end users are not computer literate enough to perform this task. Any help would b greatly appreciated. I'm also letting you know that I am new to access and have limited knowledge of database programming.