This formula =DateAdd('d',-[Days Out],[Start Date]) is in a form that is in spreadsheet view. Why am I unable to sort or do a orderby in this field. Yhe other fields can be sorted but this one will not. Is it because there is a calculation? Is there a work around?

Thanks

Move the expression into the query that you are using for your form's recordsource. You will then be able to sort on it in your form.

Peter,

Thanks for the reply. Unfortunately the record source is a table. This is not a database that I set up. I know enough to get myself in "trouble" to make changes to the database. Although I do not know enough to change the record source to a query without breaking everything else. Is there any other work around?

I can't think of any issues arising from changing from a table to a query as the recordsource.
Obviously do a backup first.

Click the 'build' button (...) to the right of the table name in the form's recordsource property. That will take you to the query builder.
Add all fields (*) to the grid and then add the dateadd expression..
Close - you will get a message asking you to confirm that you want update the recordsource.

Try it and see.