A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Dues Query



 
 
Thread Tools Display Modes
  #1  
Old July 9th, 2008, 08:24 PM posted to microsoft.public.access.queries
DNork
external usenet poster
 
Posts: 5
Default 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  
Old July 9th, 2008, 08:49 PM posted to microsoft.public.access.queries
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default 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  
Old July 9th, 2008, 09:10 PM posted to microsoft.public.access.queries
Klatuu
external usenet poster
 
Posts: 7,074
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.