how do i get a report on single department in asset tracking?

[Guest]

would like to design a report whereas i can selectively report on a single
department in the asset tracking database?

 

[Duane Hookom]

Try these methods:
http://www.fontstuff.com/access/acctut08.htm
or http://www.mvps.org/access/reports/rpt0002.htm

 

[Guest]

Finally got the dialog box to work, but really need all data pertaining to a
particular department, i.e., assets assigned. purchase date, price, etc.,
etc. Only pulling up department name?

 

[Duane Hookom]

Just include all the other stuff you need in the report's record source and
then bind some text boxes to the other stuff.

 

[Guest]

Thank you very kindly, Duane. However, being a new user I'm still in the
dark on this one. What I would like to do is generate a query i.e.,
department name, etc., etc., etc. and have that query result in the
generation of a report that I can print and present to a customer.

 

[Duane Hookom]

Are you asking how to create your tables or your queries or your reports or
what?

How far have you gotten with this? Do you have tables?

 

[Guest]

Okay, let's see if I can explain this so that you'll understand. I am using
the Microsoft "Online" access tracking database as a model. So everything
has been properly defined. I am able to generate a query based on a given
department within this database; however, I was hoping to do more that just
generate a query "listing" but, generate a "formatted" report from the query.
Phew. Hope you get the idea.

I also noticed that the query generates a "blank" record if any of the query
fields contains a "null." How do I overcome that, except require that the
field contains something other that a "null" (blank)?

 

[Duane Hookom]

If you can "generate a query based on a given department" then use the query
as the record source for your report.

I don't clearly understand what you issue is with Nulls. You might need to
use LEFT or RIGHT joins in your query.