help

[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!

 

[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?

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]