saving filter

A

andrewgill2001

I have a table with the following columns:
ProgrammeID, ChannelID, Programme Name, Programme Desc, Startdate,
starttime, category, duration

What I would like to do is sort by Startdate, then starttime. I can do
this, but cannot find anyway to save it. If I copy and paste one of the
records, then change starttime, I have to keep clicking to sort it.
How do I set it up, so it always shows it sorted by startdate then
starttime?

Many thanks for your help
 
V

Vincent Johns

I suggest you not bother with editing the Table at all. You can get the
same effect (with the sorting) via a Query like this:

SELECT MyTable.*
FROM MyTable
ORDER BY MyTable.Startdate, MyTable.starttime;

You could edit your records via this Query in Datasheet View just as you
could your Table in Table Datasheet View.

However, if you have time, I suggest you define a Form based on your
Query, and use the Form to do the data entry/editing, especially if you
intend to have other people edit the Table.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
E

Ed Warren

Don't work with the table, build a form based on the table and set the sort
property of the form to StartDate asc, StatTime asc

Ed Warren
 
L

Larry Daugherty

It seems you are messing with your data directly in the tables. This
ain't Excel, Dude! In Access you create forms and their underlying
queries. Thereafter you never get into your tables for anything but
to check or change the design.

Make a copy of your database. Open the database, select your table,
click the Autoform Wizard Icon. Step through the wizard choosing the
form type, etc. Let the wizard finish. Voila, you have a form.
While that form isn't yet going to present sorted data, it will work!
Enter a couple of records. As you complete a record, click on the
right pointing arrow in the little box at the bottom of the form.
Once you've got that going, switch the form to design mode.

Look in Help for guidance on anything I tell you that you don't yet
know how to do. In design mode, click on the Properties icon to get
at the form's properties. When the property window opens, click on
the Data tab. In that tab, the line labeled Record Source will have
the name of your table in the window. Click the ellipsis (3 dots) at
the far right. You'll be warned that you're about to invoke a query
builder on a table. That's just what you want to do so click Yes.
The Query Builder/QBE Wizard will open. It will display a form with a
window in the upper portion and a grid in the lower portion. In the
window will be a little box representing your table and listing all of
the fields in your table. At the very top of that list is an
asterisk. Click and drag the asterisk from the table down to the
leftmost Field cell in the grid below. The asterisk means "all
fields". Be sure there is a check mark in the Show window below the
asterisk. Click and drag the names of the fields you want to sort by
into the Field windows below. Place them in the order that you want
them to take effect. In the Sort window below the field name select
Ascending or Descending sort for that field. Also, remove the check
mark from the Show box in each of those single fields you dragged down
to the grid. Those fields are already being shown. Now the fun:
click the Red exclamation mark on the toolbar. The data from your
table will be presented, sorted as you directed. If it didn't come
out just right, get back into design mode and fiddle with things and
try again until they do. Click the X in the upper right corner to
quit the wizard. Yes, you want to save your changes. No, you do not
want to create a named query. By answering the questions that way
you'll end up with an embedded SQL statement as the Record Source.

All of the above can be found in the book 'Running Microsoft Access
[YourVersion" Step by Step" from Microsoft Press. Actually, any
version is better than none.


HTH
 
Top