question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make a report of my library lists. One of the tables includes the different categories that the books are separtated into. I want to make my report by separating the books into these categories. I got everything to work the way I wanted it to, but instead of having the category titles in the report it puts the category number. I checked the source and it appears that it should be showing the category title instead of the number, so I can't figure how to get it to show the title. I would appreciate any ideas that you have!
 
Hi

i bet you used the LOOKUP WIZARD to create the link between one table and
the categories table and that you had an ID number as the primary key on the
categories table? if so, you have two choices:
1) edit the record source of your current report (in design view, bring up
the report properties, click on the ALL tab, click on record source, click
on ... in the query window add in the category table (if necessary) and
select the category title field from this able), close the query using the X
and say "yes" to updating the SQL, now click on the field list icon on the
toolbar and drag the category title down next to the category number - view
the report, it should look okay now

or
2) create the report from scratch
- i always find creating a query and then basing the report on that the best
way to go, so create a select query using the table with all the info you
want and the category table, be sure to include the category title field in
your selected fields (you don't need the category number field if you don't
want it) then save the query and use the report wizard to build a report
based on the query.

Hope this helps - let us know how you go
Cheers
JulieD


help said:
I am trying to make a report of my library lists. One of the tables
Click to expand...
includes the different categories that the books are separtated into. I want
to make my report by separating the books into these categories. I got
everything to work the way I wanted it to, but instead of having the
category titles in the report it puts the category number. I checked the
source and it appears that it should be showing the category title instead
of the number, so I can't figure how to get it to show the title. I would
appreciate any ideas that you have!
 
That helped me very much! Thank You! I have another question though. Right now I have the category and the books underneath the category. Some of the books have multiple authors, and I have a separate authors table, and I want to put the authors into the report as well. When I have multiple authors, it repeats the book title, date, etc. for as many authors as I have. I don't want it to do this. I just want it to put the title and everything once and then put as many authors as there are into that one area. How do I do this?
 
Hi

if i'm understanding you correctly you will need to group on book as well as
on category
group on category first, then on book (same screen in the wizard, just
select each one in turn and use the >)

let us know how you go.

Cheers
JulieD

help said:
That helped me very much! Thank You! I have another question though. Right
Click to expand...
now I have the category and the books underneath the category. Some of the
books have multiple authors, and I have a separate authors table, and I want
to put the authors into the report as well. When I have multiple authors, it
repeats the book title, date, etc. for as many authors as I have. I don't
want it to do this. I just want it to put the title and everything once and
then put as many authors as there are into that one area. How do I do this?
 
Back
Top