var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a control with Totals, =[fieldA]+[fieldB] .
When it is displayed on the form as in a Datasheet, I cannot select the column for Sort, what can I do?
One option is to build a query with a new field that contains [FieldA]+[FieldB], then sort the query by that field, then bind the form to that query.
What version of Access are you working in? If it's 2000 or later, you can add the calculated field to the result set in the 'Record Source' property of the form. If you need more details I can post a quick step by step if that helps.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors