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.
Thanks,
Kristen—
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];
to
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
