Question about best method

[tdanko128]

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.

[pbaldy]

Typically you would have all the payments in one table, with a date field. You can use a parameter query to draw out payments for a given time frame. You can create a form that users enter the desired dates, and your query criteria would be

Between Forms!FormName.txtFromDate And Forms!FormName.txtToDate

[tdanko128]

Thank you Pbaldy...