Re: [LegacyUG] Access Query of Legacy Database

2007-10-08 Thread Jim Liddil
Another approach to this is to use something like FlySpeed SQL Query to query the tables. SQL is not that difficult to learn and FlySpeed gives you a more graphic interface. Access SQL doesn't truly follow the standard. And once you know SQL you can certainly develop your own reports beyond what

[LegacyUG] Access Query of Legacy Database

2007-10-06 Thread Cedric Wyndham
Dear Forum Members, I am trying to produce a report that will be a start off point for us to produce an updated address list for all living descendants of an ancestor who has 2,500 descendants, ie too many to create the report by manual means. We don't know who among this 2,500 is still living,

Re: [LegacyUG] Access Query of Legacy Database

2007-10-06 Thread Cathy
Instead of working in Access, you can get what you want from the Name List/Search List in Legacy. Tag the people you want and show that tag number in the Name List. Go to Print, choose the fields you want If I understand you, RIN, Surname, Given Names, Birthdate, Address Name, Address - pick