Access 97-macro to hide columns and sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use Access 97 and would like to create a macro to hide columns and sort by
eg.field1,and field 2,ascending. Is a macro the best way to do it?and if so
how do I do it?
 
Maud0361,

No, this probably does not involve the use of macros. This is a job for
a Query. Make a new query based on your table, add only the fields from
the table that you are interested in, and within the query design apply
any sorting and calculations required. You would then typically base a
Form or Report on the query, for the purposes of viewing or editing the
data.
 
Back
Top