Microsoft Access Question (related to web)
Drew, Bill
drewwe at MORRISVILLE.EDU
Wed Apr 11 09:58:17 EDT 2001
I am using Microsoft Access to compile a page that I will put on the web of
all electronic serials we have and what databases they are in. My problem
is in that Access puts in a blank line for the output of a subreport even
when there is no data for that particular title. My database is set up with
a separate table for each vendor all linked to a table contain only titles
(one to many relationship). My report is based on a query of the title
table with holdings fields displaying as subreports for each vendor table.
I am getting lots of empty lines. I can get rid of them in Word but it is
extremely time consuming. Any ideas?
___________________
Wilfred (Bill) Drew
Associate Librarian, Systems and Reference
SUNY Morrisville College Library
E-mail: mailto:drewwe at morrisville.edu
BillDrew.Net: http://billdrew.net/
Not Just Cows: http://people.morrisville.edu/~drewwe/njc/
Library: http://www.morrisville.edu/library/
Wireless Librarian: http://people.morrisville.edu/~drewwe/wireless/
Have Laptop -- Will Travel.
"The early bird may get the worm, but the second mouse gets the cheese!" --
Author Unknown
More information about the Web4lib
mailing list