I am trying to filter my data by two different fields.  The first is the account and the second is the department.  When I try to filter by departments it does not include anything that does not have a department.  I tried left outer join on the department but it won't let me...."Failed to retrieve data from the database.  Database Connection Error: If tables are already linked then the join type cannot change."  I also tried to select records by account and then group select  by department.  As soon as I put the department anywhere it drops out my records that don't have a department.  I need to select within a range plus nulls or exclude a range.  Help?

My data comes from a data warehouse.  I may be able to get access but I'm not familiar with stored procedures.  I'm trying to write an income statement and it is a bit cumbersome.  I'm not sure if I'm going about it the right way....using many subreports.

Hey that error you're getting happens when you have several fields (probably from different tables) that you're joining on and you're doing an outer join with one table and an inner join with another.

The other thing you can do is get a little fancy with your select expert formula, so for example you can have different conditions setup when the department is null than when it isn't. So if I understood correctly, something like:

if not isNull({Table.Dept}) then
(
   {Table.DateField} >= {?StartDate} and
   {Table.DateField} <= ?EndDate}
)
else
(
   true
)