Hello, I have built an Access Database to track guest for a wedding. I built a report that resembles the floor plan of the dinning room at the venue.
Each square box represents a table located in the dinning room.
Each guest is assigned a table name which is contained in their record with in the database.
I added a text area to the box and have attempted to use the Expression Builder to read the database to select and display their names on their assigned table.
The main purpose is to provide a map so that the staff at the venue will be able to lay out the placement cards on the correct tables.
Here is the expression i tried to use, its not throwing an error, but its always returning false.
=IIf([Notes]='Lucca',[First Name] & ' ' & [Last Name] & ' ' & [Spouse First Name] & ' ' & [Spouse Last Name],'Empty Table')
"NOTES' is the name of the column in the database where i store the table name.
My query SQL Statement looks like this,
SELECT Contacts.[First Name], Contacts.[Last Name], Contacts.[Spouse First Name], Contacts.[Spouse Last Name], Contacts.Notes
FROM Contacts
WHERE (((Contacts.Notes)="Lucca"));
This is also returning zero records even though i now for a fact their is one record with the value of Lucca in the "NOTES" column
Any help would be very much appreciated.
I apologize for being new to this forum, and if I have posted my question in the wrong place or if I haven't provided enough detail,
I promise to all of you to learn the proper etiquette here on this forum. And I'll make it my goal to contribute only high quality content.
Thanks again!
James Creston