Alphabetical Order by Topic

[Guest]

Hi,

I'm working on a program and it needs to be in order by date, time, topic
order, and description. I'm currently lookin in Design View and not sure if
this is the correct way to do this. What I want to do is put the topic order
in order. For instance, right now the order is "In The Workplace,"
"Blind/LV," "Cognitive," etc. How do i put the topic in order? Do I need to
run the query and the final look will be in the order?

Thank you in advance for your feedback/advice.

Marie

 

[Larry Linson]

I'm working on a program and it needs to be
in order by date, time, topic order, and description.
I'm currently lookin in Design View and not sure if
this is the correct way to do this. What I want to
do is put the topic order in order. For instance,
right now the order is "In The Workplace,"
"Blind/LV," "Cognitive," etc. How do i put the
topic in order? Do I need to run the query and
the final look will be in the order?

You don't put "programs" in order. You can order data in Queries, in Forms,
and in Reports. But, you give some examples but don't really explain either
what you have or what you are trying to accomplish. If you'll do both, then
there's a high probability someone may be able to make a useful suggestion.

Forms display records in the order specified in the Query or SQL Statement
that is used as the Form's RecordSource. Reports, on the other hand, ignore
the order of the Record Source and Sort and Group according to what you have
specified in the Report's Sorting and Grouping Properties.

If you plan to display Tables in Datasheet View, you can't control the
order. If there is a Primary Key on the Table, they will _normally_ display
in Primary Key order, but that is not guaranteed.

Larry Linson
Microsoft Access MVP