Re: Can't figure this out
- From: "Steve" <help_available_at_very_reasonable_rates@xxxxxxxxxxxxx>
- Date: Mon, 6 Jul 2009 11:45:29 -0400
The standard table of names has LastName, FirstName and MiddleInitial. To
display the names in alphabetical order in a form or report you need to
create a query based on that table. The query must have the LastName field
with the soty set to ascending. Then you have the option to display the full
name as three separate fields or you can use a calculated field to display
the full name in one textbox:
FullName:[FirstName] & " " [MiddleInitial] & " " & [LastName]
Steve
santus@xxxxxxxx
"Richard Lukin" <richardlukin@xxxxxxx> wrote in message
news:9664C8EE-C310-4D90-A125-FD151A8DFD8D@xxxxxxxxxxxxxxxx
Your problem suggests if you have a moment that you might be able to help
me figure out how to alphabetize listrs of names, etc. MS Help is
useless--doesn't even list the subject. "Sort" used to do it in XP,
but.....
Richard NYC
"DUNNER7" <DUNNER7@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F4788418-995F-4C13-A783-C41C827291A3@xxxxxxxxxxxxxxxx
I have 3 tables, 1 with over 1,000 student names, student ID primary key,
2nd
table has discipline incidents each incident has a unique id and is has
the
student id as a link to the student demographic table, the 3rd table has
11th
grade test scores it has about 200 records and each is identified by the
student id number. When I try and create a form using the form wizard
the
form count for records only shows about 200 or so records. Why doesn't
have
the over 1,000 records and the records that have discipline and test data
linked should show that. I do not know if I explained this clearly, but
I
cannot figure it out.
Del Dobbs
.
- References:
- Re: Can't figure this out
- From: Richard Lukin
- Re: Can't figure this out
- Prev by Date: Re: Linking form information to specific tables
- Next by Date: Re: Divide One Field into 3 parts
- Previous by thread: Re: Can't figure this out
- Next by thread: Re: Can't figure this out
- Index(es):
Relevant Pages
|
