98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access: Adding Calculated Field
Access: Adding Calculated Field
Resolved · Medium Priority · Version 2010
Wed 21 Mar 2012, 16:53Delegate Lyndon said...
Lyndon has attended:
Access Intermediate course
Access Advanced course
Access: Adding Calculated Field
I would like to add a conditional calculated field in a table. The table contains dates, products and product-sales-values. I am looking for a calculated field to calculate the weight of the Product sales, per date, regardless of the number of rows of data per date. e.g. For Each month the aggregate product's sales for January as a percent of the total (all) products' sales for January
Fri 23 Mar 2012, 11:03Trainer Anthony said...
RE: Access: Adding Calculated Field
Hi Lyndon, thanks for your query. Sounds like what you need is the equivalent of the DSUM function in Excel. Have a look at this:
http://www.lqexcel.com/domainaggregate.php
Hope this helps,
Anthony
Thu 29 Mar 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Relationship mapsIt is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes |
