Query Setup for Access2007

[LibrarianIndiana]

I have 2830 DVD's in a Table. There are 6 Different Libraries
that own various combinations of these 2830 DVD's. How do I
set up Query's to end up with separate Reports on each of the 6 Libraries?

I want a Report for each Library's DVD's. I tried to use criteria
of No Null entries but since it was a stacked query it didn't work.

TIA

IndianaLibrarian

 

[Dale Fye]

It would be helpful if you could describe your table structure (the DVD
table, Libraries table, and DVD_Libraries table). This assumes that you have
a many-to-many relationship between libraries and dvds, and have the
appropriate linking table (dvd_libraries). If not, give us the structure you
have and someone will see if we can help.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[John Spencer (MVP)]

What is the table structure?

A good design would have a table for DVD's, a table for Libraries, and a table
for Libraries that own that DVD. With only 6 libraries, you could eliminate
the libraries table if you wanted.

If your structure is one table with fields like
DVDName
LibraryOneHas
LibraryTwoHas
LibraryThreeHas
LibraryFourHas
LibraryFiveHas
LibrarySixHas
then you could use a union query as the source to get the information.

So, step one - describe your table structure.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Gina Whipp]

Yesterday, you posted this under Reports and I asked for additional
information. Are you not seeing replies to your post?

 

[LibrarianIndiana]

I can't find the original post. Can you reply here?

 

[Gina Whipp]

Actually, same as ohers, need to see SQL and table set-up

 

[LibrarianIndiana]

Question. What do you mean by "table structure"?
I do not know how to 'link'.

T.

IndianaLibrarian

 

[Gina Whipp]

What are the field names in your table or tables that you are refering to.

 

[LibrarianIndiana]

I have one table. This has the DVD's in the first column
and then to the right are the 6 different libraries.

Actually, I just finished Queries for each Library.

Fiels: DVD Title
Table: Sheet1
Sort: Ascending
Show (Checked)
Criteria: Is Not Null

This made pretty good looking things with
the DVD Title in one column and the numbers of copies
in the second column. The headings for the Columns are
'DVD Title' and the Library name. Most columns have a '1'
in them for one copy.

Now I need to print out Reports. How?

TIA

IndianaLibrarian

 

[Gina Whipp]

Have you tried to create a report using the wizard? SImply go to the report
tab and press new, then follow along.

 

[LibrarianIndiana]

I tried the Report Wizrd.
Nothing much happened.

I got way too much space between DVD titles. There were like 50 pages for
1000 DVD Titles. I want about half as many pages. How do I fix this?

How is the Report formatted?

TIA

IndianaLibrarian

 

[Gina Whipp]

You will have to go into design mode and move the fields closer together.