Jass Saini
asked on
Copy a record and Update the record
Hello,
Here is my problem I want to be able to take a record..copy the record and update certain fields based off the form...
here is what I have ...
Name Program and how much is funded to the program. The user needs to change the "how Much"...but the key is there are several "How Much"...such as salary, communication, Equipment..etc. So I have no way of knowing what is changed. I want to be able to copy the record and have the user input the new number ...while I still have the orginal record.
Here is my problem I want to be able to take a record..copy the record and update certain fields based off the form...
here is what I have ...
Name Program and how much is funded to the program. The user needs to change the "how Much"...but the key is there are several "How Much"...such as salary, communication, Equipment..etc. So I have no way of knowing what is changed. I want to be able to copy the record and have the user input the new number ...while I still have the orginal record.
ASKER
Hello Rey,
Sorry...maybe I was not clear. My boss created a crosstab table and she wants me to use the as my storage table. We eventaully want to upload to a different system....if that makes sense
Sorry...maybe I was not clear. My boss created a crosstab table and she wants me to use the as my storage table. We eventaully want to upload to a different system....if that makes sense
ASKER
Also, it's there an easier way??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am just having a hard time with this DB as my boss is so unclear about what she wants and knows as much as I do about Access
see this links
http://allenbrowne.com/AppAudit.html
http://support2.microsoft.com/?kbid=197592