Sorting Tables

  • Thread starter Thread starter C#''er
  • Start date Start date
C

C#''er

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
 
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 said:
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 said:
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?
Click to expand...
Click to expand...
 
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?
Click to expand...

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/accessjunkie/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
 
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 said:
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 said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
It sounds like you need a seperate table for cities or state if that is what you are searching by. Link this table to the table sitting behind your main form. You could then populate a combo box with cities. On the after update event of the combo box would run a find record macro to move to your required record based on your city or state filter.

-------------------------------------------------------
For your FREE Access beginners ebook

http://www.access-databases.com/ebook

-------------------------------------------------------
 
Back
Top