Percentage Formula for Imported Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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.
 
Back
Top