Match or Lookup

A

Andy

Hi,

Basically from a years worth of sales data I want to identify what value of
business was written by a Sales Area in 3 week of 2006 - what formulas do I
need to look at? Note: I don't need to sum week 3 as the total value is
already given.

The week no. and Sales Area are the key identifiers here.

am a novice so simpleton terms are appreciated.
 
W

Wayne-I-M

Hi Andy

Create a new query based on the table(s) which contain the week number and
Sales Area infomation.

In the query column (containing week number and sales area) click on the
Criteria row.
You can either prompt the user to insert the information like this
[Please enter week number]
[Please enter sales area]

Or - if you only want a specific set of results, you can simply enter the
week number into the criteria row directly and also the sale area number

Hope this helps
 
Top