Re: Order by property and OrderByOn

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
    ... realtionships before trying to create the query. ... > The form is now based on a TableA that is made up of underlying tables ... >>> My reference book says to use Order by property in the table and ... >>> even find the OrderByOn property for the form. ...
    (microsoft.public.access.gettingstarted)
  • Re: IF THEN in query..Maybe IIf
    ... assuming that there is a primary key for the existing records in the data ... table, which i'll call TableA, that matches a primary key in the imported ... now turn the query into an Update query. ... if the data file has the person's home ...
    (microsoft.public.access.queries)
  • Re: Limit numbers in primary key
    ... autonumber field per table. ... the same properties as the corresponding field in TableA. ... Add a field or whatever your primary key field is and set it as ... Create a Query. ...
    (microsoft.public.access.gettingstarted)
  • Re: Advanced query issue
    ... and then write a query linking just by your new ... FROM tablea As a RIGHT JOIN tableb as b ... That assumes tableb has all the possible occurrence of the two ... I also used UNION ALL, ...
    (microsoft.public.access.queries)
  • RE: filter for values in another table
    ... The other way is to use the IN Clause in your SQL statement. ... SELECT TableA.* ... WHERE TableA.ID NOT IN (SELECT DISTINCT ID FROM TableB)" ... runs is to create a query that some people call a "frustrated outer join". ...
    (microsoft.public.access.queries)