Okay a tricky one here...

I have a database of cities I have been to and everytime I have been
there I reenter the city. It is business related so there are more
fields associated with each record. Anyway, I want to count how many
times I have been in each city without having to enter a city's name
because I just want the database to figure out that and not have to
type in Chicago anyware. That way when I am in a new city I can just
create that record and it will come up with something.
Anysuggestions. ????

In article <1181137935.938283.43690 (AT) o5g2000hsb (DOT) googlegroups.com>,
mattG <mgohring (AT) gmail (DOT) com> wrote:

Sounds like you are looking for a couple of different things.

You can create a value list of cities, using the field City as the
source of the value list. On the layout, format the field to display a
drop-down list of the cities from that value list. Then all you have to
do is pick from the list. If it is a new city not on the list, you type
in the name, and it will thereafter appear in the value list.

As for count of each city that is a different matter.

You can define a Summary field Count of Cities. Then create a layout
that has a Subsummary part when sorted by City, and put the summary
field Count of Cities in that subsummary part. Also put the field City
in the subsummary part, as a label.

--
For email, change <fake> to <earthlink>
Bill Collins

On Jun 6, 9:52 am, mattG <mgohr... (AT) gmail (DOT) com> wrote:
1. Create a summary field in your table that counts the number of
records

2. Summary Report
New layout - Columnar List/Report
[x]Report w/ Grouped Data
[x]Include subtotals
[x]Include grandtotals
Include and sort by the cities field on the report,and create
subtotals and grandtotals using your summary field
(:
good luck!

(also, so you dont have to re-enter city titles, in "Field Setup" you
can use a value list and [x] "Auto complete using previously entered
values")