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
|
|||
|
|||
Which Query
Situation: I have a table with many fields including a "status field" and a
"dues amt" field. Status is either "member, "Non member" or "LOA Member". I am looking for a method to do a mass replace of the current data in the dues column based upon a question I receive when I run the query. I do not want to write a new query every time the dues change. I thought this was a parameter query application but I can't seem to get the row column and value set up properly. What query is appropriate and what is the set up? Thanks |
#2
|
|||
|
|||
Which Query
I'm not real clear on what you are trying to do...
If you did a "mass replace of the current data", what would you be changing it to? ... and why? What does "a question I receive" have to do with your decision/mass replace? If you do a "mass replace", will you ever regret not having saved the previous data? You've described a "how" you want to do something, but what that something is, and the underlying business need, is not clear. More info, please... Regards Jeff Boyce Microsoft Office/Access MVP "DNork" wrote in message ... Situation: I have a table with many fields including a "status field" and a "dues amt" field. Status is either "member, "Non member" or "LOA Member". I am looking for a method to do a mass replace of the current data in the dues column based upon a question I receive when I run the query. I do not want to write a new query every time the dues change. I thought this was a parameter query application but I can't seem to get the row column and value set up properly. What query is appropriate and what is the set up? Thanks |
#3
|
|||
|
|||
Which Query
Hi Jeff
I am creating a database that will be maintained by someone else. They will maintain the database using various menus and forms. They will not be functional on Access programming. They will not have direct access to the tables, queryies, macros etc in the design mode. I could do a simple update query every time the dues fee changes; however I want to take myself out of the maintenance process as much as possible. Okay more explanation. The database tracks various data on both union members and non-members of a bargaining unit. Members are paying union dues each month. That data is tracked in the column "dues amt" for the non-members this field contains a zero (0) while members have a fee, say $10.00. The "status" field tracks the employees as a "member, non-member, Resigned or LOA member" Periodically the monthly dues change. What I hope to be able to do is program an action button on a menu (run query?) that would respond with a screen question (what are the new dues amt?). The database manager would input the new dues amt which would then update (based upon critera)all "member and LOA member" records with the new dues, say $15.00. "Non-member and resigned" should not have any records updated. No regrets about unsaved data. All member records have the same amount. If operator input the wrong number they would just rerun the update process. Thanks for your help "Jeff Boyce" wrote: I'm not real clear on what you are trying to do... If you did a "mass replace of the current data", what would you be changing it to? ... and why? What does "a question I receive" have to do with your decision/mass replace? If you do a "mass replace", will you ever regret not having saved the previous data? You've described a "how" you want to do something, but what that something is, and the underlying business need, is not clear. More info, please... Regards Jeff Boyce Microsoft Office/Access MVP "DNork" wrote in message ... Situation: I have a table with many fields including a "status field" and a "dues amt" field. Status is either "member, "Non member" or "LOA Member". I am looking for a method to do a mass replace of the current data in the dues column based upon a question I receive when I run the query. I do not want to write a new query every time the dues change. I thought this was a parameter query application but I can't seem to get the row column and value set up properly. What query is appropriate and what is the set up? Thanks |
#4
|
|||
|
|||
Which Query
Thanks for the clarifications.
If this were mine, I'd create an update query that used your dues field in the first line, your prompt [New dues amount?] in the 'update to' line and a set of selection criteria that got you the dues-paying folks only. After creating the query, I'd add a command button (probably using the wizard) and tell it to run the query. BEFORE clicking the button, I'd make sure I have a backup copy of the database (not a bad idea before doing a bulk-update. Good luck! Regards Jeff Boyce Microsoft Office/Access MVP "DNork" wrote in message ... Hi Jeff I am creating a database that will be maintained by someone else. They will maintain the database using various menus and forms. They will not be functional on Access programming. They will not have direct access to the tables, queryies, macros etc in the design mode. I could do a simple update query every time the dues fee changes; however I want to take myself out of the maintenance process as much as possible. Okay more explanation. The database tracks various data on both union members and non-members of a bargaining unit. Members are paying union dues each month. That data is tracked in the column "dues amt" for the non-members this field contains a zero (0) while members have a fee, say $10.00. The "status" field tracks the employees as a "member, non-member, Resigned or LOA member" Periodically the monthly dues change. What I hope to be able to do is program an action button on a menu (run query?) that would respond with a screen question (what are the new dues amt?). The database manager would input the new dues amt which would then update (based upon critera)all "member and LOA member" records with the new dues, say $15.00. "Non-member and resigned" should not have any records updated. No regrets about unsaved data. All member records have the same amount. If operator input the wrong number they would just rerun the update process. Thanks for your help "Jeff Boyce" wrote: I'm not real clear on what you are trying to do... If you did a "mass replace of the current data", what would you be changing it to? ... and why? What does "a question I receive" have to do with your decision/mass replace? If you do a "mass replace", will you ever regret not having saved the previous data? You've described a "how" you want to do something, but what that something is, and the underlying business need, is not clear. More info, please... Regards Jeff Boyce Microsoft Office/Access MVP "DNork" wrote in message ... Situation: I have a table with many fields including a "status field" and a "dues amt" field. Status is either "member, "Non member" or "LOA Member". I am looking for a method to do a mass replace of the current data in the dues column based upon a question I receive when I run the query. I do not want to write a new query every time the dues change. I thought this was a parameter query application but I can't seem to get the row column and value set up properly. What query is appropriate and what is the set up? Thanks |
Thread Tools | |
Display Modes | |
|
|