Microsoft Access
--
Questions
--
Followers
Top Experts
Access 2016 concatenation problem
I'm trying to create a directory for contacts, and I'm trying to put Prefix, FirstName, and LastName together, but it gives me the error #Type!. Â The error indicator in Design View says it's a circular reference (image attached). Â I only have one other table with a relationship to the main Contacts table, off which I'm making the form. Â Could this be causing the problem? Â What other info do I need to provide to help with this problem?
Thank you!
ScreenHunter_827-Dec.-14-14.39.jpg
Thank you!
ScreenHunter_827-Dec.-14-14.39.jpg
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Can you show the entire expression for the Control Source.
And the RecordSource for the Form ?
And the RecordSource for the Form ?
Absolutely! Thank you
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Well ... seems the Record Source does not include Prefix or Last Name ?
Can you show the Full SQL for the Record Source ?
Can you show the Full SQL for the Record Source ?
Is this where it's located? Â I'm looking for the SQL view, but it's not there.
ScreenHunter_833-Dec.-14-15.38.jpg
ScreenHunter_833-Dec.-14-15.38.jpg
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.