Search results

The problem is the concatenating together of the fields to make the address "appear" to be one field. I dont know the syntax as outlined in my first post (based on the fact the address fields are all prefixed like QueryName.AddressField) -- when I try to concatenate, I get #Name error in the...

The fields are stored in an Address Table. Address is linked to Account (Many Addresses to one Account). The Account is linked to Inventory. (1 Account can have Many Inventory Machines). The form is Inventory Data, but I have a Tab that contains Account Info, with their Addresses. Does this...

I want to store about 5 address fields concatenated into one long text field. Thanks. Mike

Hi I did a search to no avail... I am trying to concatenate Address fields into one text box. The Control Source pull-down menu gives me the Field Names listed as QueryName.ColumnName. I know that if they listed the fields as just ColumnName, you'd simply go: ColumnName & " " &...

Ok, The relationship i have is 1 Account can have Many Addresses. My form contains Account information, but I also want to display ALL addresses the Account might have (it could be 1, or it could be 3 or more). Whats the best way to do this besides having a bunch of text boxes -- is there a...

Hi All, I'm a noobie with Access, and on my form which displays Account information, I also want to display the multiple Addresses this account can have. I can't find any type of scrollable text box (something to look like a spreadsheet), and I know it's not a list box I need to use. How do I...