Hi, I am a librarian, and I have a database that someone else has programming in 1997 by using MS Access '97. It has 7 tables. Three of them are the point of my question.
Table1 has 8 fields: id, Bookid, Title, Topicid, PublisherName, DateofPurchasing, Price, CoverType. Table2 has 3 fields: Authorid, AuthorFirstName, AuthorLastName. Table3 is connection between two previous tables, and has 3 fields: BookAuthorid, Bookid (which is the same as Bookid in Table1), Authorid (which is the same as Authorid in Table1). My database has main form which is based on Table1, and it's subform, based on Tables 2 and 3. In subform (about authors) the designer of database put together AuthorFirstName, AuthorLastName in one row by sql statement. When he designed a reports to make catalogue of books and authors, he used the same sql statement to put together AuthorFirstName, AuthorLastName in one row. It is very much shown in Design mode of both reports, but in Preview mode all I saw last year when I started to work in that library were a title of those reports. Please, any one, help me. I am working with MS Access 2003 now. ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
