Updating percentages in a form

[Guest]

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]

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

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]

 

[Guest]

Thanks!

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

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]

 

[Guest]

Thanks!

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

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]