Access: Adding Calculated Field

Resolved · Medium Priority · Version 2010

Wed 21 Mar 2012, 16:53 Delegate 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:03 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Relationship maps

It 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

Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips