--- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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 >
Thanks, John, for your concern. My report is blank in Print Preview, although it has only one thing on a top, and that is a title of the report. I could not find any queries in the database, b ut I did find a VBA statements for main form and it's subform. If you are interested I could post it to you by e-mail next time. Once again, thanks a lot! ------------------------ 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/
