Re: Order by property and OrderByOn

My objective is to create a behavior incident reporting and tracking database
for the school in which I work. Staff members will input descriptions of
incidents as they come up. The first form is for staff input. Another form
which is built on the same table as the first but with added fields, will be
used by administrators and detention room folks who deal with each incident.
The Tables are composed of:
Table 1) Student names with with home address, phone, etc.
Table 2) Staff names, which includes all staff in our school.
Table 3) Incident description Table 4) General time of day (during class,
during lunch, between classes, etc., and Table 5) a list of consequences
applied by staff
As I started this task, I noticed that there were no common fields in
these tables upon which to build relationships. So my efforts to build
queries have not worked.
Instead, I built another table, the TableA referred to earlier which is
otherwise called tbStuldent_Behavior_Log. This table is built the
"underlying tables", i.e., contains fields from first five tables. In this
table, the unrelated data that would describe a single behavior incident is
combined together in records. The records are created by staff members and
stored in tbStuldent_Behavior_Log.
I've not seen how to accomplish that same thing using queries.
A NEW observation is that when Table 1 mentioned above (students with
addresses) includes the 5 digit student ID number, that field overrides any
attempt I'm made based on previous suggestions, to sort by a different field.
When I went back to the Table 1 and deleted the student ID field, the sort
order remained as imported, which is ascending by student last name. But
when the student ID field is present, Access sorts by it. Problem is, while
not totally necessary, I'd like to have the student ID field in the table.
While I'm sure there are more elaborate approaches to this goal, as a
newbie, I can't think of any other way to do it and I don't see the
forthcoming hidden problem with this approach.
I do appreciate all you the patience and will appreciate any further
comment/direction.

"BruceM" wrote:

> You have lost me (and probably quite a few others as well) when you said
> that the table is made up of other tables. What do you mean by that? A
> table could have been created by combining two or more tables, but a table
> is a container for data, not for other tables. It would help if you list
> your table fields and relationships, and include a brief general description
> of your database's purpose. You would probably do better if you created the
> realtionships before trying to create the query. Table relationships will
> be carried through to any queries based on those tables.
> If you cannot get a query to work, that issue is worth the effort of
> addressing. Attempting to work around something that should not have been a
> problem in the first place is likely to lead you nowhere.
>
> "Hughie" <Hughie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:372C6046-50A5-4F24-9C77-755AD0EADB9E@xxxxxxxxxxxxxxxx
> > I've not been able to make a query work.
> > The form is now based on a TableA that is made up of underlying tables
> > that
> > have no related fields:
> > TableA contains a table of student names and demographics, a table of
> > teacher names, and several other tables, again, that have no related
> > fields.
> > It has worked best to build the form on TableA.
> > When I try to build a query on TableA, the query returns a record for
> > (what
> > appears to be) every combination of fields. As a newbie, I'm not
> > familiar
> > with the different types of queries. I'm confused when I add the tables
> > in
> > Query Design view, that there's no way to associate the tables and thus I
> > can't control the join properties.
> >
> > Another point I've forgot to mention before is that the tables, regardless
> > of what I do in the Order by property and the OrderByOn code, are being
> > sorted on a numeric field in the TableA.
> >
> > "Ed Robichaud" wrote:
> >
> >> One of the simpler methods is to create a query that sorts your data
> >> however
> >> you like, then set the record source of your form to that query.
> >> -Ed
> >>
> >> "Hughie" <Hughie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:4FE5009E-7513-4DAC-806A-2B2D1CCDAD37@xxxxxxxxxxxxxxxx
> >> >I want to have my form set to sort by a particular field each time it
> >> >opens.
> >> > My reference book says to use Order by property in the table and
> >> > OrderByProperty in the form.
> >> > Problem is book doesn't say how to use the Order by property and I
> >> > can't
> >> > even find the OrderByOn property for the form. Please advise. Thanks.
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Order by property and OrderByOn
    ... The first form is for staff input. ... > Table 1) Student names with with home address, phone, etc. ... >> realtionships before trying to create the query. ... >>> The form is now based on a TableA that is made up of underlying tables ...
    (microsoft.public.access.gettingstarted)
  • Re: Updatable Query (trying to edit records)
    ... the query so some fields are lookup fields. ... The only reason the Staff table is ... CABudgetHrs to arrive at the budgeted $ for that assignment. ... two tables ClientAssignment and Staff. ...
    (microsoft.public.access.queries)
  • Re: HEY Jerry dink
    ... Ah HA here we go....you are not on staff at any of the local DZ's SO ... Its just the nature of the business, ... the little wino's who show up to drink up all the student beer. ... I see them as drunken mooches...make last load even back then and the ...
    (rec.skydiving)
  • the last one
    ... considered as staff, and are employed for specific projects. ... Class Student ... PeopleContainer * GetStudents/*returns another container containing ...
    (comp.lang.cpp)
  • Re: AD structure for a school environment
    ... You have to assume that servers in the untrusted network are "dirty". ... parent staff domain and child student domain. ... staff PCs to the student file server. ...
    (Focus-Microsoft)