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]