Do you mean that the report is blank when you open it in Print Preview? If so, then the query must be filtered in some way so that it returns no rows. What happens if you open the query in Datasheet view? Is there any data to display?
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of ivcebos Sent: Thursday, November 03, 2005 5:25 AM To: [email protected] Subject: [ms_access] A little problem with reports 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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
