Sorting Tables

i dont know how to ask this question, so bare with me please. i have an
Access form that is linked to a table. The table has columns for Name,
Number, Date, City State and so on. I dont know what it is called or even how
to refer to it, but I know there is an option for me to seperate the date by
coumns. For instance, if I only wanted to view the people with addresses in
Georgia, there would be a tab in the navigation pane named Georgia, and when
I clicked on this tab, only the Georgia people would apppear. How do I do
this?

Before you do anything else, change the names of some of those
fields/columns in the table. I'm taking you literally when you say you have
a column named [Name], and another named [Number], and another named [Date].
These are reserved words in Access, so when you use them, you and Access may
be referring to different things.

Next, if you have a field (?[Name]) that contains a full name (first,
middle, last, suffix), break that apart into separate fields. A common rule
of database design is one fact, one field, so adding together all those name
parts in one field makes more work for you (and Access) than having separate
fields. For example, how would you sort by last name?

Now, if you are considering doing this directly in the table, STOP! Access
tables may look like spreadsheets but they aren't. Access tables store
data, Access forms (and reports) display data. Use Access forms (check out
the tab control in Access HELP).

What you are describing is do-able ... for someone with experience designing
Access forms and graphical user interfaces. Do you have experience in both?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"C#''er" wrote in message
...
i dont know how to ask this question, so bare with me please. i have an
Access form that is linked to a table. The table has columns for Name,
Number, Date, City State and so on. I dont know what it is called or even
how
to refer to it, but I know there is an option for me to seperate the date
by
coumns. For instance, if I only wanted to view the people with addresses
in
Georgia, there would be a tab in the navigation pane named Georgia, and
when
I clicked on this tab, only the Georgia people would apppear. How do I do
this?

Yes I have experience using windows forms and GUI's, however not much
expierence in access. So far I have only built windows app's in C# using
Visual Studio. And the columns arent literally named "name" and such, more
like: First, Last, date called and particularly City. City is the one im more
focused on as of this point. From what I read in your reply, I would need to
create a report (or multiple reports) for each city that seperates the
information. I.E. if I were to make a report for the city of Miami, and
clicked on that report, then only the people whose city has been logged as
Miami would show up. Am I right? If so, how do I do such a thing?

"Jeff Boyce" wrote:

Before you do anything else, change the names of some of those
fields/columns in the table. I'm taking you literally when you say you have
a column named [Name], and another named [Number], and another named [Date].
These are reserved words in Access, so when you use them, you and Access may
be referring to different things.

Next, if you have a field (?[Name]) that contains a full name (first,
middle, last, suffix), break that apart into separate fields. A common rule
of database design is one fact, one field, so adding together all those name
parts in one field makes more work for you (and Access) than having separate
fields. For example, how would you sort by last name?

Now, if you are considering doing this directly in the table, STOP! Access
tables may look like spreadsheets but they aren't. Access tables store
data, Access forms (and reports) display data. Use Access forms (check out
the tab control in Access HELP).

What you are describing is do-able ... for someone with experience designing
Access forms and graphical user interfaces. Do you have experience in both?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"C#''er" wrote in message
...
i dont know how to ask this question, so bare with me please. i have an
Access form that is linked to a table. The table has columns for Name,
Number, Date, City State and so on. I dont know what it is called or even
how
to refer to it, but I know there is an option for me to seperate the date
by
coumns. For instance, if I only wanted to view the people with addresses
in
Georgia, there would be a tab in the navigation pane named Georgia, and
when
I clicked on this tab, only the Georgia people would apppear. How do I do
this?

On Tue, 13 Jan 2009 06:56:04 -0800, C#''er
wrote:

i dont know how to ask this question, so bare with me please. i have an
Access form that is linked to a table. The table has columns for Name,
Number, Date, City State and so on. I dont know what it is called or even how
to refer to it, but I know there is an option for me to seperate the date by
coumns. For instance, if I only wanted to view the people with addresses in
Georgia, there would be a tab in the navigation pane named Georgia, and when
I clicked on this tab, only the Georgia people would apppear. How do I do
this?

Read Jeff's comments - you're making some mistakes that can easily be fixed
now, maybe a lot more work later!

The tool you want is a "Query", and queries are absolutely fundamental to any
productive use of Access. Get to know and love them.

Here's some resources that might help - start with one or both of the
Tutorials.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
--

John W. Vinson [MVP]

Check John's response -- you don't need (or WANT!) to make one report per
city. Instead, use a query to return information, by city, then base a
report on that query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"C#''er" wrote in message
...
Yes I have experience using windows forms and GUI's, however not much
expierence in access. So far I have only built windows app's in C# using
Visual Studio. And the columns arent literally named "name" and such, more
like: First, Last, date called and particularly City. City is the one im
more
focused on as of this point. From what I read in your reply, I would need
to
create a report (or multiple reports) for each city that seperates the
information. I.E. if I were to make a report for the city of Miami, and
clicked on that report, then only the people whose city has been logged as
Miami would show up. Am I right? If so, how do I do such a thing?

"Jeff Boyce" wrote:

Before you do anything else, change the names of some of those
fields/columns in the table. I'm taking you literally when you say you
have
a column named [Name], and another named [Number], and another named
[Date].
These are reserved words in Access, so when you use them, you and Access
may
be referring to different things.

Next, if you have a field (?[Name]) that contains a full name (first,
middle, last, suffix), break that apart into separate fields. A common
rule
of database design is one fact, one field, so adding together all those
name
parts in one field makes more work for you (and Access) than having
separate
fields. For example, how would you sort by last name?

Now, if you are considering doing this directly in the table, STOP!
Access
tables may look like spreadsheets but they aren't. Access tables store
data, Access forms (and reports) display data. Use Access forms (check
out
the tab control in Access HELP).

What you are describing is do-able ... for someone with experience
designing
Access forms and graphical user interfaces. Do you have experience in
both?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"C#''er" wrote in message
...
i dont know how to ask this question, so bare with me please. i have an
Access form that is linked to a table. The table has columns for Name,
Number, Date, City State and so on. I dont know what it is called or
even
how
to refer to it, but I know there is an option for me to seperate the
date
by
coumns. For instance, if I only wanted to view the people with
addresses
in
Georgia, there would be a tab in the navigation pane named Georgia, and
when
I clicked on this tab, only the Georgia people would apppear. How do I
do
this?