Search results

Dear Sir, I have tried the query as suggested, but still all the addresses are being displayed in combo box. This will not be feasible for me, as when i will have total 100 plants, then combo box will display 100 addresses, then it will be easy to type the address rather than finding and...

Dear Sir, Thanks for your reply. Query is as follows: SELECT [Plant Details].Address FROM [Plant Details], [Daily Entry] WHERE ((([Daily Entry].[Customer Name])=[Plant Details]![Customer Name])) ORDER BY [Plant Details].Address, [Daily Entry].[Customer Name] Please be noted that i am totally...

Dear Forum, I have three tables in access 2007 as follows: 1. Customer Details: Which contains the customer details such as, customer name, address, city, state, phone, email, website, contact person, contact person number, contact person email, and finally web address. 2. Plant Details: This...