By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,991 Members | 1,887 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,991 IT Pros & Developers. It's quick & easy.

Updating Table records

P: n/a
As a distributor of products ....... I have a table which includes my
CostPrice. CostPrice is used in various queries, forms and reports. My
supplier ups my price by 5%. I can use a query to calculate
NewPrice:[CostPrice]*1.05.

What is the best/accepted method of geting the value of NewPrice into the
CostPrice field for the queries, forms and reports to continue to function
as before?

Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Use an update query.

"Update <table name> SET <table name>.CostPrice = " & <table
name>.CostPrice * 1.05 & ""

The query can be executed via code (if you need to automate it) or just
manually run.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.