Re: Order by property and OrderByOn

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
    ... 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 ... >> 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)
Loading