Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2007

Tip: Looking for answers? Try searching our database.

Updating percentages in a form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Connie - 05 Jul 2007 04:24 GMT
Hi all,

Using Access 2003.  I would like to use a form to call certain data and then
apply a percentage increase to that data.  The data is all in one table.

There will be 100 or more records to be called and increased.

So far, I have created a query with the following criteria:
i)  [Enter year] in the year field,
ii) Between [Enter beginning range] and [Enter end range] in the percentage
field.

No problem with this in the form.  It does what it is supposed to do.  Now I
need to apply the increase.  Hopefully I have given you enough info.

Any help is appreciated.

Connie
John W. Vinson - 05 Jul 2007 06:55 GMT
>Hi all,
>
[quoted text clipped - 14 lines]
>
>Connie

Change the query to an Update query and on the Update To line put

[fieldname] * 1.06

to update all the selected records' fieldname to 6% higher.

            John W. Vinson [MVP]
Connie - 06 Jul 2007 04:22 GMT
Thanks!

> >Hi all,
> >
[quoted text clipped - 22 lines]
>
>              John W. Vinson [MVP]
Connie - 06 Jul 2007 04:24 GMT
Thanks!

> >Hi all,
> >
[quoted text clipped - 22 lines]
>
>              John W. Vinson [MVP]
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.