In message <fkqubs+cgqk@xxxxxxxxxxx>, Ken <ken.poyser@xxxxxxxxxxx> writes >In the result display window > >It list the > >ORI Phone Numuber Ageny Name >OK0990000 405 -555-0000 PD SOMEWHERE > > >what I would like to have it list the number of records that >OK0990000 has entered whereas it would display > >ORI # of Rec Phone Number Agency Name >OK0990000 45 405 555-0000 PD SOMEWHERE What's causing confusion, is that your database does not appear to be designed properly. There should be 2 tables: officetable: ORI (assume that this is the office ID), PhoneNumber, AgencyName missingpersontable: ORI (the office where the person is registered), personname, whatever else... Do you have a record for every single missing person in a single table, with the office name and phone number in each record? Still not sure what ORI is - is it something that is obvious to an american? -- Pete Clark Sunny Andalucia http://hotcosta.com/Andalucia.Spain
