You keep on using the term "field." Where do you come across it in XL?
Also, a PivotTable is for output analysis of data, not for data entry
or storage.

For a *very* brief intro into what the tables should look like see
Building and using a relational database in Excel
Introduction to a relational database
http://www.tushar-mehta.com/excel/ne...cel/intro.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
In the Excel Help menu, the Field button is indicated for the PivotTable. I
have several column headings, such as Name, Address, Phone, etc. I have
several entries under each heading, and I then need to extract certain
information into reports, such as names of those in certain cities, and those
with birthdays after a certain date.

I started by creating a spreadsheet with all the information, but perhaps I
should have made the column labels into fields first. But I don't know how to
do any of this.

"Anne Troy" wrote:

Where are you getting "field button"? The best way is to simply put column
headings in row 1, and your first record in row 2. Other than that, we'll
need more information.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Kenn Holmberg" <Kenn wrote in message
...
I am a new user, and am required to create an Excel database. Any hints
would
be helpful. The online documents are not clear. Also, where is the "Field
button" ?I am using 2003 Standard Edition.