Report on multiple departments

  • Thread starter Thread starter ALR
  • Start date Start date
A

ALR

Can anyone help me please. I would like to do report on a
form, but I would like to report on multiple items in the
field. For example, I want to report departments Finance,
Tech Support, and Research. The only problem is that when
I put in several departments, my report comes back blank.
I should add that my report is based on a query that is
based on a table.
Thank You
 
I get a result if i put in one department name in the
criteria in my query, but if i put in more than one
department name I get a blank page.
 
that might be because of your query definition inner/outer
joins.
by default the query displays data when there's info for
the one side of a one-to- many relationship. if you want
to see all data in the many side you should modify your
query.
 
I think the problem is with how do you "put in" several
departments. Make sure you realize that when you just
type multiple names in without the proper AND or OR
statements your query will be looking for the concatenated
name, which does not exist in your table.
For instance
you have departments "one" and "two"
if you enter "one" as filter you will filter to all
records for department "one" etc.
Now if you wish to filter for departments "one" or "two",
you will have to enter the filter as such and not as "one
or two".
Hope this helps.
Fons
 
Back
Top