Getting a tables column to sort on ascending

[Lou_Reed]

I am trying to get the following table to sort on ascending ysnMeetingID. It is not doing that now.

I have included a file snippet attached to this email of what the table looks like now.. Please explain how I may do that?

Any help appreciated. Thanks in advance.



Respectfully,

Lou Reed

[ranman256]

make a query, sort on the field.

[Bulzie]

Or you might be able to right-click in that column, then see if there is sort options to use in the pop up menu.

[Lou_Reed]

Okay, that might work. But please understand that there are only 4 ysnMeetingID's to sort on. So there will obviously be a lot of repeats. A lot people attend each meeting. I am just confused as to how to do it. I thought you could do it in the table design. You did not need to make anything more than just a table design.

I will try what you said.

Thanks,

Respectfully,

Lou Reed

[orange]

Perhaps your data structure is working against you?? Your table is called attendance, but it includes invitation info, relates to 4 meetings (it seems) and several participants.

What is the PK of this table?
AttendanceID?

It seems at first blush --did Person XXX attend meeting TTT ==> Yes or No
not Present, Absent, N/A,


See this data model and look at the roster table to see how attendance is set up.

[Lou_Reed]

I was thinking of doing something like that shown in the attached file. By that I mean indexing right from the tale design. It seems
the best and easiest way.

If I do a query, which is of course was one of my first thoughts, wouldn't that move this table into the query section? I want the tblAttendance to remain
right where it is now, just sorted on ysnMeetingID in ascending order.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Bulzie]

Lou why do you need a table sorted a certain way. Are you letting users open this table directly to do something which is a very bad idea?

[Lou_Reed]

No, in the table above, I just found a way to do it. The question is now overcome by events. But many thanks for your help.

By the way, I would like to freeze people out from working on the tables. How do I do it?

I do not want people users of the db messing about on the objects of my db.

AnY help appreciated. Thanks in advance.

Respectfully,

Lou Reed