Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sort subform descending

Status
Not open for further replies.

Smack

Technical User
Apr 20, 2001
261
US
In my main form, Pricing, I have a subform which contains the actual price records. In A97 i used the sort by in the subforms properties. In A2K it added brackets around the first field. If i don't use a bracket, I get prompted. My A97 was sorted
Date, Entry Date, DESC
Anyone know how I can get this to work?
-Smack

 
Forget it. I went ahead and added a query and sorted it the way I want it. I thought it might slow accessing the form too much, but it was okay.
My date field is =Now()but I added this later on. the records wer imported from another system, so I have about 1900 records where that field is null. How would I write an expression that If Null then date =2-1-01?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top