Re: Query Setup for Access2007

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" wrote:

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

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
"LibrarianIndiana" <LibrarianIndiana@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:95CC34B2-4B4C-4EC0-B799-B537035BBAAB@xxxxxxxxxxxxxxxx
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




"John Spencer (MVP)" wrote:

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

LibrarianIndiana wrote:
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






.

Relevant Pages

  • Re: Query Setup for Access2007
    ... Have you tried to create a report using the wizard? ... and then to the right are the 6 different libraries. ... Fiels: DVD Title ... then you could use a union query as the source to get the information. ...
    (microsoft.public.access.queries)
  • Re: Query Setup for Access2007
    ... I got way too much space between DVD titles. ... How is the Report formatted? ... "Gina Whipp" wrote: ... and then to the right are the 6 different libraries. ...
    (microsoft.public.access.queries)
  • Midwest Book Review: The Library DVD Shelf
    ... The Library DVD Shelf ... 20525 Nordhoff St. Suite 200, Chatsworth, CA 91311-6104 ... library DVD collections and the libraries of anyone curious about the ... The Midwest Book Review is an organization of volunteers committed to ...
    (alt.video.dvd)
  • MBR: The Library DVD Shelf
    ... The Library DVD Shelf ... wonderful contribution to yoga and fitness DVD libraries and is highly ... called The Big Apple in Columbia, South Carolina and the dance craze ... The Midwest Book Review is an organization of volunteers committed to ...
    (alt.video.dvd)
  • MBR: The Library DVD Shelf
    ... The Library DVD Shelf ... Blu-ray library strong in natural history will find this a winner! ... Blasters is an excellent supplement to fitness DVD libraries. ... The Midwest Book Review is an organization of volunteers committed to ...
    (alt.video.dvd)