How to analyse data?
Competent Performer
Windows 7 64bit 
Access 2013
Hello all, my problem today is that I have the same product provided by 2 different manufacturers. So ideally I would like to calculate the total amount that I have, and the amounts that i get from each manufacturer. I don't know weather is best as a query or do it with in a form using vba. Any ideas would be appreciated. Thank you for your help.
VIP
Windows 7 64bit Access 2010 32bit
A report would be best - use its Sorting & Grouping features with aggregate calcs in group and report footer sections.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 7 64bit Access 2013
Thank you for your reply. It is a very good idea. I will just do that.
Posting Permissions
Reply With Quote