Search results

I have used this code which works on one field. How would I change the code to concatanate multiple fields. For example at the minute I call it in a query like this: Act: ConcatRelated("[TODO_CD] & Chr(13) & Chr(10)","Export_act","[OPTY_ID] = """ & [OPTY_ID] & """") This works on one...

Hi, I have a table called Export_Car which contains Data such as License Number and Make and Model. I am calling a VBA function (in my query) that I have found online. This works fine and concatanates all the License Numbers for that Dealer. ConcatRelated("License & Chr(13) &...

Hi, I have a table called Customers: I have a column called Address With Records like this: Address Farm, Long Road, North I want to use a Carriage Return query to make the record read like this: Address Farm Long Road North I know I can use Chr(13) and Chr(10) within the query. But...

Hi, I have: Tables: Customer and Orders Relationship: Customer ID is the primary key in Customer and is a foreign key in order table. I need to create a Form with contains all the customer info from the customer table, as a drop down list. Once the customer is selected, all their orders...