Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Question Unanswered: Sort by Calculated Field in Datasheet

    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?

  2. #2
    Join Date
    Oct 2009
    Posts
    204
    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.

  3. #3
    Join Date
    Sep 2010
    Posts
    10
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •