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

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

Guest

would like to design a report whereas i can selectively report on a single
department in the asset tracking database?
 
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?
 
Just include all the other stuff you need in the report's record source and
then bind some text boxes to the other stuff.
 
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.
 
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?
 
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)?
 
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.
 
Back
Top