Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Access 2007 - chapter 11 - no way to recreate groups and sorts

Very disappointing! Chapter 11, Access manual 2007, page 350-353. The example groups and sorts are impossible to recreate. There is no "CategoryName" offered on the drop down menu because it comes from another table. Any attempt to reference the other table via "expression" does not re-create the group that is already there. Generates errors, crashes Access, doesn't display what the existing groups did. If this is the "missing manual", then explain, how, exactcly, the groups and sorts in the "FudgeBoutique" were created from scratch and explain what all the filter SQL code is and how this was created.
1 person has
this question
+1
Reply
  • Hello Sean -- Sorry to hear you had a problem. I'm checking with the author and will let you know.

    Nan Barber
    Editor
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned happy, confident, thankful, excited kidding, amused, unsure, silly

  • Here's the author's reply:

    CategoryName does indeed come from another table, but it's still available for grouping thanks to the table relationship. The sample database for this chapter includes several reports, including one named GroupedProductCatalog that shows this example.

    The "filter SQL code" is generated automatically by the report generator. We describe its syntax to some extent in the book, but we don't give enough information for you to write it by hand.

    Can you be specific about what happens when you say, "crashes Access"? It seems unlikely that an error creating a report would cause a program crash. If you're indeed experiencing this, there could be a deeper installation issue.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned happy, confident, thankful, excited kidding, amused, unsure, silly