Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Percent markdown caluclation on datasheet

Posted on 2011-02-23
Medium Priority
504 Views
I have a datasheet form that I need to do some calculation on, the control source is a query qryEdit.  There is a  SellingPrice which has a value in it, a ShowPrice which will be a minus percentage of the SellingPrice  column. For example if the sellingPrice is \$100 and the Showprice is -10% of the sellingPrice , the value in the Showprice  would be \$90.00. I would like to have the user enter the value, in this case 10,  in a column PrctMakDwn and have it calculate the Showprice and place the marked down value in that column. The percentage will vary for different items, Is that possible?
0
Question by:skull52
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 40

Accepted Solution

als315 earned 2000 total points
ID: 34963635
Yes, you can do any calculation in after update event for your fieds (sellingPrice and PrctMakDwn)
Me.Showprice = Me.sellingPrice*(1 - me.PrctMakDwn)
In this case PrctMakDwn should have percent field format (if it will be double, divide it to 100)
0

Author Comment

ID: 34964641
Worked perfectly, Thanks. One quick followup, is there a way on the datasheet that you can bulk copy and paste similar to excel when you fill in a cell you can drag that value down to the rest of the cells?
0

Author Comment

ID: 34965098
Forget my last question regarding the cut and paste, even though it looks like a spread sheet it is a database and that would be against normalization and bad design. so thanks again for the quick response
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
###### Suggested Courses
Course of the Month9 days, 23 hours left to enroll