Apr 26 2012, 08:08 PM
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?
Apr 27 2012, 02:31 AM
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.
Apr 27 2012, 06:35 AM
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?
Apr 27 2012, 08:06 AM
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here