Search results

Nick This is brilliant. Thanks for this. Is it possible to select, for the fourth type of office (Foreign Office), any office where Not Equal to the first three types? Regards GS

In Access 2000, how can put various records from one table where one field contains same value, into one record adding extra fields. I have attached the example in an attached spreadsheet. First sheet describes what other sheets contain and what I want to achieve. thanks.

Jon Thank you for you reply. this is great and will help me in something else I am trying to do. I have attached an excel workbook to simplify, what I was trying to achieve with this. There are four sheets, first sheet describes other worksheets and what I am want to acheive. Many thanks.

Table ChipNo Location(L) 1st Reg(1st) Last Reg(Last) 511 A 8/12 8/13 511 B 8/13 8/14 511 C 8/15 8/16 511 D 8/17 513 B 8/25 8/25 513 D 8/27 8/28 How can I list all the records from above table in one...