{
      "eprint_status": "archive",
      "title": "Queries that Really Count: Understanding Totals in Access\r\n",
      "userid": 24,
      "date": "2012-05-10",
      "divisions": [
        "eluna_conf"
      ],
      "datestamp": "2012-05-25 22:11:41",
      "event_type": "conference",
      "date_type": "published",
      "pres_type": "lecture",
      "subjects": [
        "voyager"
      ],
      "event_title": "ELUNA 2012",
      "eprintid": 876,
      "metadata_visibility": "show",
      "documents": [
          {
            "docid": 1088,
            "format": "application/vnd.ms-powerpoint",
            "main": "B_7_09_Salika.ppt",
            "uri": "https://beta-documents.el-una.org/id/document/1088",
            "mime_type": "application/vnd.ms-powerpoint",
            "files": [
                {
                  "objectid": 1088,
                  "mtime": "2016-05-27 21:06:11",
                  "datasetid": "document",
                  "uri": "https://beta-documents.el-una.org/id/file/15242",
                  "mime_type": "application/vnd.ms-powerpoint",
                  "fileid": 15242,
                  "filename": "B_7_09_Salika.ppt",
                  "filesize": 1028096
                }
            ],
            "language": "en",
            "security": "validuser",
            "rev_number": 3,
            "pos": 1,
            "eprintid": 876,
            "content": "presentation"
          }
      ],
      "event_dates": "May 9-11, 2012",
      "event_location": "Salt Lake City, Utah ",
      "refereed": "FALSE",
      "type": "conference_item",
      "abstract": "The more you know about how Access counts things, the more accurate and useful your queries will be.  We\u2019ll take a look at the basics of counting, ways to handle date ranges, and crosstabs.  This session, for beginning and intermediate query writers, is an update of a session given at ELUNA 2010.\r\n",
      "ispublished": "pub",
      "uri": "https://beta-documents.el-una.org/id/eprint/876",
      "rev_number": 9,
      "full_text_status": "restricted",
      "dir": "disk0/00/00/08/76",
      "lastmod": "2016-05-27 21:06:11",
      "creators": [
        {
          "name": {
            "lineage": null,
            "given": "Cathy",
            "honourific": null,
            "family": "Salika"
          }
        }
      ],
      "item_issues_count": 0,
      "status_changed": "2012-05-25 22:11:41"
    }