ordering by multiple fields

[mikeder]

this should be a simple problem. I have a form that contains the following fields:

Year
FileNumber
ProposalPhase
JobPhase

There are approximately 2000 project entries in my dbase.

What I want to do is sort these project entries by FileNumber first, then by ProposalPhase, then by JobPhase, then by Year. I can only get it to sort by FileNumber right now. Anybody have suggestions on how to rank order your sort order?

thanks

 

[Jack Cowley]

Create a query and put the columns in this order:

FileNumber, ProposalPhase, JobPhase, Year

Set the sort order for each as you want it.

hth,
Jack