I need to first determine the quarter , then retrieve a value from each of the 6 fields for that quarter and compare that value against a previous years value that is also stored in the table for each quarter.

Where multiplier is the value you are multiplying by the value TotalNetUSExp (T1E, T2E, ...)

Then to get the Multiplier you would simply use a query or a DLookup within that table for the record where the value you are testing for falls between the Min and Max values (actually >=MinVal AND < MaxVal)

It was just an example I used not an actual value, then I went back an reposted the actual values.

Dale,

Unforunately, this is the way the data is, it comes from a datawarehouse. I inherited the data The entire mdb is not normalizated, not referential intregity. a real mess, but I not here to fix the issues just create a report based on existing data.

Got any ideas on how to loop thru the data to get the results.

Where multiplier is the value you are multiplying by the value TotalNetUSExp (T1E, T2E, ...)

these are additional fields within the same table. The Q?T? fields contain a percentage that I need to compare to the previous years percentage(PY). and if PY is compared until the Q?T? value is greater than the PY for that quarter - to return an dollar amount based on the above mention equation.

Normalization, How would you go about accomplishing this task?

I had this thought last night.

I under an extreme deadline I only have 1.5 weeks left on this assignment. I could really use your help.

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®.
Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…

I see at least one EE question a week that pertains to using temporary tables in MS Access. But surprisingly, I was unable to find a single article devoted solely to this topic.
I don’t intend to describe all of the uses of temporary tables in t…