 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2005Percentage Formula for Imported Reports
I imported 2 reports from an excel file. One report is for the previous month and the other from the current. The fields are the same if I am making a query, but the updated report has new numbers in the total field. I have to show the differences betwwen last month's totals and this month's totals in a percentage format. Please help! First, what is an Excel "Report". Is this data in columns and row, like a table? Where are you putting this "Report" in Access?  SignatureSteve Clark, Access MVP http://www.fmsinc.com/consulting *FREE* Access Tips: http://www.fmsinc.com/free/tips.html >I imported 2 reports from an excel file. One report is for the previous >month [quoted text clipped - 4 lines] > in a > percentage format. Please help! Yes, it has colums of information and these are the fields: Cust. # Cust. Name SKU Code Qty Rate Total Amt. Co. Code Product GL Period The GL periods are dates in this format 200511 (November 2005). Basically I am importing these reports into access to get a comparoson report out of it. I have to take the total amt columns for the past two GL periods and compare them to find out if there has been an increase or decrease, and I need to put that into a percentage. > First, what is an Excel "Report". Is this data in columns and row, like a > table? [quoted text clipped - 9 lines] > > in a > > percentage format. Please help! The Group By operator will allow you to sum the data. A percentage is Part/Whole. So, do one query for the Whole, and one query for the Part. Link the Part and the Whole Queries to make the pct. > Yes, it has colums of information and these are the fields: > [quoted text clipped - 28 lines] >> > in a >> > percentage format. Please help! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.