I have tended to steer clear of calculated fields in Access. Now at the start of my journey of migrating data to SQL server, I notice it is possible to create calculated columns there too.
Are these a good idea? Any insights, tips and advice gratefully received!
Alex Lewis
@Reply 23 hours ago
What are you trying to do calculations on?
David OrrOP
@Reply 15 hours ago
Hello Alex, in Access I have a query that concatenates contact details in a range of ways, e.g. First + Last, Last + First, Title + First + Last, Address1 + Address2 + PostalTown + County + Postcode - for convenience and consistency with, for example receipts, mail merge, lookups and so on.
Alex Lewis
@Reply 8 hours ago
You can concatenate column values using computed columns in SQL Server. It’s basically the equivalent of string concatenation in Access. For example:
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
