I have searched for information on this, but can't find anything. I am new to Access, so maybe I missed something somewhere. If so, please point me to it.
I have a simple database, and have made a grouped report of addresses. Very simple report with an alphabetic grouping with a header that is the first letter from the last name [FileAs]. I want the letter for that group to appear above the group so users know they are looking in the "A" for the last name. This is what I use in the group header.
=UCase(Left(Nz([FileAs]),1))
Looks great, works fine I save everything and reopen the database. The above code no longer works. I get a #Name? error. If I cut it out and past it in again, works great, but close the database and same problem. If I retype it, same problem. Everything is in the same database. The only one using it now is me. Why does it lose the reference on opening? And most importantly, how do I fix this?
I found one old thread about "Group by First letter!", but that's not my problem. I would very much appreciate input!
I have a simple database, and have made a grouped report of addresses. Very simple report with an alphabetic grouping with a header that is the first letter from the last name [FileAs]. I want the letter for that group to appear above the group so users know they are looking in the "A" for the last name. This is what I use in the group header.
=UCase(Left(Nz([FileAs]),1))
Looks great, works fine I save everything and reopen the database. The above code no longer works. I get a #Name? error. If I cut it out and past it in again, works great, but close the database and same problem. If I retype it, same problem. Everything is in the same database. The only one using it now is me. Why does it lose the reference on opening? And most importantly, how do I fix this?
I found one old thread about "Group by First letter!", but that's not my problem. I would very much appreciate input!