{
      "eprintid": 465,
      "lastmod": "2016-05-27 21:04:41",
      "abstract": "Access queries that count, total, or group data can be tricky. This session will take the guesswork out of counts and totals and give you the confidence that your numbers are actually correct. If you have ever written a query that uses more than one table and a criterion, you have all the background you need to follow this presentation. ",
      "corp_creators": [
        "Consortium of Academic & Research Libraries of Illinois"
      ],
      "title": "Queries that Count: Understanding Totals in Access ",
      "item_issues_count": 0,
      "date": "2010-05-12",
      "subjects": [
        "voyager",
        "gen"
      ],
      "event_dates": "11-13 May 2010",
      "event_title": "ELUNA 2010",
      "documents": [
          {
            "eprintid": 465,
            "pos": 1,
            "security": "public",
            "uri": "https://beta-documents.el-una.org/id/document/601",
            "relation": [
              {
                "type": "http://eprints.org/relation/hasVolatileVersion",
                "uri": "/id/document/2091"
              },
              {
                "type": "http://eprints.org/relation/haspreviewThumbnailVersion",
                "uri": "/id/document/2091"
              },
              {
                "type": "http://eprints.org/relation/hasVersion",
                "uri": "/id/document/2091"
              }
            ],
            "main": "ELUNA2010-Salika-Queries.pdf",
            "mime_type": "application/pdf",
            "files": [
                {
                  "mime_type": "application/pdf",
                  "fileid": 8844,
                  "filesize": 1185949,
                  "filename": "ELUNA2010-Salika-Queries.pdf",
                  "datasetid": "document",
                  "uri": "https://beta-documents.el-una.org/id/file/8844",
                  "mtime": "2016-05-27 21:04:41",
                  "objectid": 601
                }
            ],
            "content": "published",
            "rev_number": 4,
            "format": "application/pdf",
            "docid": 601,
            "language": "en"
          }
      ],
      "event_location": "Fort Worth, Texas",
      "full_text_status": "public",
      "type": "conference_item",
      "event_type": "conference",
      "userid": 3,
      "pres_type": "paper",
      "refereed": "TRUE",
      "eprint_status": "archive",
      "metadata_visibility": "show",
      "datestamp": "2010-05-26 18:00:50",
      "uri": "https://beta-documents.el-una.org/id/eprint/465",
      "dir": "disk0/00/00/04/65",
      "ispublished": "pub",
      "status_changed": "2010-05-26 18:00:50",
      "rev_number": 12,
      "divisions": [
        "eluna_conf"
      ],
      "creators": [
        {
          "name": {
            "given": "Cathy",
            "honourific": null,
            "lineage": null,
            "family": "Salika"
          }
        }
      ],
      "date_type": "published"
    }