Search results

Thanks for quick reply! SQL below SELECT DISTINCTROW [Supplier Contacts].Contact FROM [Supplier Contacts]; I realise probably something missing. Company on the form is pulled from a different table to Supplier Contacts.

Hello all My first post, I hope I make sense! I have a form that lists companies associated with a job. I have created a combo box that I want to list all contacts associated to each company that can be selected by the user. Currently my combo box only shows one contact in the dropdown at a...

Hi all, I'm Emma and a new user of access in the last eighteen months. I have transferred an excel stored 'database' of subcontractors for my company to an access set up that I have built with a colleague. Although I'm sure not the most streamlined of builds! Now flying the flag solo, I thought...