Marking up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am tring to mark up several products in a query by 10%, I know this is
simple but I have went blank on it.
Please Help
 
Hi,

You need an update query. First make a backup of the table or, better yet,
the entire database just in case somethig goes bad.

Create a select query that includes the field needing to be marked up. Run
the query and make sure that you have only the records that you need. If not,
you'll need to modify the criteria for the Products field to get only the
correct records.

After you have the select working correctly go to design view of the query.
On the toolbar select Query, Update Query.

In the Update To row under the column needing update put something like so:

[TheNameOfTheColumnAbove] * 1.1

Run it.
 
Back
Top