MS Access Issues

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 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.

Kristen Cameron
Program Assistant
Writing in the Disciplines

Access is a beastly app, but I managed to tame it. It amounts to changing the query that populates the Attendee field in the RSVPs table from

SELECT [Constituents].[ID], [Constituents].[Last Name], [Constituents].[First Name] FROM Constituents ORDER BY [Last Name], [First Name], [ID];


SELECT [Constituents].[ID], [Constituents].[Last Name], [Constituents].[First Name], [Constituents].[Department] FROM Constituents ORDER BY [Last Name], [First Name], [ID]; 

Then go to the Create ribbon and create a new data sheet-style form

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

About Wesley Wright

Born on a mountain top near New York City, Craziest state in the land of the pretty. Raised in the woods so's he knew every tree, Killed him a bear when he was only three.
This entry was posted in Wes and tagged , . Bookmark the permalink.