help

K

Kelly

I have a Field that contains Canadian Postal Codes (a1b 2c3), US State
Names(Texas) and country names (France). I need to calculate percentages of
visitors by setting up a promt to enter a region or postal code.

Any ideas how to set up criteria/statements/formulas to do this?

Thanks in advance!
 
J

John Vinson

I have a Field that contains Canadian Postal Codes (a1b 2c3), US State
Names(Texas) and country names (France). I need to calculate percentages of
visitors by setting up a promt to enter a region or postal code.

Any ideas how to set up criteria/statements/formulas to do this?
Click to expand...

I'm confused. This is *one* field which contains any of these three
disparate levels of data?

And "percentages" implies a ratio of two numbers. You can easily count
the number of occurances of Texas or Laos or A1B 2C3 in the field,
using a Totals query - but what's the denominator of the ratio?

John W. Vinson[MVP]
 
Top