I'm altering a database to have certain fields be recorded monthly.
For example: instead of a client's file having "Total X Purchased" it would now be "Total X Purchased - Jan", "Total X Purchaed - Feb".
I want to spin the monthlies out of the master clients table & in to ex. tbl_clientsJan, tbl_clientsFeb, etc. but still have them linked; & have a "Totals" table that aggregates data from all of the tables (adds them up).
What's the best way to set this up?
I have an existing form, & I was thinking of just creating tabs for the months & subforms in each with their sources as the month tables, & removing the fields that don't change month-to-month (e.g. client name), with relationships between them. I would start by copying all of the master table data in to the month tables & allowing edits from there.
EDIT: the company doesn't track when the transactions occurred; I'm unable to group them along those lines.
I'm new to Access & don't want to make a mistake. If anyone has any advice, or if there's a safer method to do what I want to, I would really appreciate it.
For example: instead of a client's file having "Total X Purchased" it would now be "Total X Purchased - Jan", "Total X Purchaed - Feb".
I want to spin the monthlies out of the master clients table & in to ex. tbl_clientsJan, tbl_clientsFeb, etc. but still have them linked; & have a "Totals" table that aggregates data from all of the tables (adds them up).
What's the best way to set this up?
I have an existing form, & I was thinking of just creating tabs for the months & subforms in each with their sources as the month tables, & removing the fields that don't change month-to-month (e.g. client name), with relationships between them. I would start by copying all of the master table data in to the month tables & allowing edits from there.
EDIT: the company doesn't track when the transactions occurred; I'm unable to group them along those lines.
I'm new to Access & don't want to make a mistake. If anyone has any advice, or if there's a safer method to do what I want to, I would really appreciate it.
Last edited: