{"id":861,"date":"2014-04-16T11:52:56","date_gmt":"2014-04-16T15:52:56","guid":{"rendered":"http:\/\/blog.uvm.edu\/ctl-projects\/?p=860"},"modified":"2014-04-16T11:52:56","modified_gmt":"2014-04-16T15:52:56","slug":"ms-access-issues","status":"publish","type":"post","link":"https:\/\/blog.uvm.edu\/waw\/2014\/04\/16\/ms-access-issues\/","title":{"rendered":"MS Access Issues"},"content":{"rendered":"

On Mar 31, 2014, at 11:09 AM, Kristen Cameron wrote:<\/span>

<\/p>\n

Hi Wes:<\/em>
\nI have some MS Access questions again. I’m wondering if you could show me how to show more information in queries. As it is set up know, I only have last names included. I would like to see the full name and department if possible. Do you have some time to help me with that? Not a huge rush or anything. It’s just something that has been annoying me for awhile.<\/em>
\nThanks,<\/em>
\nKristen<\/em><\/p>\n

—<\/em>
\nKristen Cameron<\/em>
\nProgram Assistant<\/em>
\nWriting in the Disciplines<\/em><\/p><\/blockquote>\n

Access is a beastly app, but I managed to tame it.\u00a0It amounts to changing the query that populates the Attendee field in the RSVPs table from<\/span>

SELECT [Constituents].[ID], [Constituents].[Last Name], [Constituents].[First Name] FROM Constituents ORDER BY [Last Name], [First Name], [ID];<\/span>

to<\/span>

SELECT [Constituents].[ID], [Constituents].[Last Name], [Constituents].[First Name], [Constituents].[Department] FROM Constituents ORDER BY [Last Name], [First Name], [ID];\u00a0<\/span>

Then go to the Create ribbon and create a new data sheet-style form<\/span>

Copy the Attendee field and paste it bak under the existing Attendee field. Paste and position again. Rename the original Last Name, the next First Name and the last Department. Edit format of the column widths of each to only show 1 column<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

On Mar 31, 2014, at 11:09 AM, Kristen Cameron wrote: Hi Wes: I have some MS Access questions again. I’m wondering if you could show me how to show more information in queries. As it is set up know, I … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41826],"tags":[42758,12386],"class_list":["post-861","post","type-post","status-publish","format-standard","hentry","category-wes","tag-boffins","tag-database"],"_links":{"self":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/861","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/comments?post=861"}],"version-history":[{"count":0,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/861\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/media?parent=861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/categories?post=861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/tags?post=861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}