If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dues Query
I have a employee database. In the database, union members are a subset of
employees, as such their "member status" is "member" or "member-LOA" while non union members are identified as "non-member" or "retired". Periodically the membership dues change for all members; non-members are not affected. When dues change all members need to have the field updated. I do not want to get involved when the dues change so I want to create a query so the database manager answers a prompt (new dues amount) when they select an action button from the menu (Update Dues). There are no issues with archiving the previous field data so just a mass update. How can I set this up? Thanks |
#2
|
|||
|
|||
Dues Query
There is an easier way.
Create a Dues_Table and left join employee table to it on "member status". Dues_Table -- Member_Status - Text Dues - Number - Single Effect_Date DateTime Archive - Yes/No Use criteria in the query on the Archive field. -- KARL DEWEY Build a little - Test a little "DNork" wrote: I have a employee database. In the database, union members are a subset of employees, as such their "member status" is "member" or "member-LOA" while non union members are identified as "non-member" or "retired". Periodically the membership dues change for all members; non-members are not affected. When dues change all members need to have the field updated. I do not want to get involved when the dues change so I want to create a query so the database manager answers a prompt (new dues amount) when they select an action button from the menu (Update Dues). There are no issues with archiving the previous field data so just a mass update. How can I set this up? Thanks |
#3
|
|||
|
|||
Dues Query
If all members dues are the same amount, then that amount should not be in
the employee table. If you have multiple unions or different member types for one union, same thing. They should not be in the employee table. You should have a Dues table that identifies the Union and/or Member Type and the dues amount should be in that table. Then all you have to do is change it in one place. The dues should then be calculated using that table. But, to answer your direct question, all you need is an update query filtered on th member status you want to change the dues for. -- Dave Hargis, Microsoft Access MVP "DNork" wrote: I have a employee database. In the database, union members are a subset of employees, as such their "member status" is "member" or "member-LOA" while non union members are identified as "non-member" or "retired". Periodically the membership dues change for all members; non-members are not affected. When dues change all members need to have the field updated. I do not want to get involved when the dues change so I want to create a query so the database manager answers a prompt (new dues amount) when they select an action button from the menu (Update Dues). There are no issues with archiving the previous field data so just a mass update. How can I set this up? Thanks |
Thread Tools | |
Display Modes | |
|
|