I'm sure there's already an answer on this forum for this seemingly simple problem but am not sure what keywords would pull the results I'm looking for so I'm hoping someone can help me out.

Running CR 10 Pro.

The report I'm working on includes Accounts, Service Orders and Contracts with the desired end result being to show all Accounts with Service Orders that have had work done that are either have never had a warranty or their warranty has expired.

So the report is configured to pull for specific records (Expired, Renewal sent, and Not Renewed ) in a field tblContract.Status which works for Accounts that have had a contract but it doesn't pull those that have never had a Contract. The current formula looks like this...

{tblContracts.Status} in [" ", "Expired", "Not Renewed", "Pending", "Renewal Sent"]

I was hoping this inclusion (" ",) at the beginning of the forumula would fix my issue but it did not. Any suggestions are appreciated!

DBlank,
Thanks for the suggestions, all of the tables in the report are set to left outer join. I adjusted the formula with the one you suggested and now its retrieving every Service Order in the database which is odd as I have a statement that tells it to only pull 3 orders, for testing purposes.

IsNull({tblContracts.Status}) or {tblContracts.Status} in ["Expired", "Not Renewed", "Pending", "Renewal Sent"]

I noticed when I go into Report Expert I get a message that says, "Formula contains a composite expression use Formula editor for editting". I've never seen that message before.

Any ideas on why this is happening?

So in the report I've configured the join types using "link options and below is the formula I used.

{tblServiceOrders.SONumber} in [266465, 266780, 266855] and
IsNull({tblContracts.Status}) or {tblContracts.Status} in ["Expired", "Not Renewed", "Pending", "Renewal Sent"]

Adding the parens seems to have done the trick for the formula. I noticed it was still pulling all records so I made some adjustments to the links and now the report seems to be working properly.

I really appreciate your insight and "staying power"! I'm curious, you're always quick with your responses and are obviously very knowledgeable with databases/CR, do you work for this site or are you simply an amazing "volunteer"?