getting name for report

[JMarie]

Hello all,
I have a search form for my user. They can pull up a report with the current balances for each customer. Works fine if the customer has a balance.
I added a pop up box for times when there is no data. However, the client wants to have the report still appear with the customer information and $0 balances. The $0 is easy enough, but I'm not sure the best way to get the customer info.

The query behind the report calls all customers with any balance.
My report uses a filter w/ the customer ID and a date range (last month/between 2 dates, etc).
I can't just change the filter to be customer ID. If the customer has a balance in a different time period it would then show that info.

Is there a way I can requery it with a different filter and different query if no records are returned?
I'm not quite sure where to start on this issue.

Thanks

 

[CJ_London]

The query behind the report calls all customers with any balance.

change this to calling all customers and a balance where one exists - i.e. a left join between your customers table and you balances/transactions table

 

[JMarie]

My sql view does have the left outer join.
My query for this report only has one table- the sql view. So I guess I should just add the customer table for the left join.
That was my initial reaction, but I'm just getting back to access work after years off and I'm questioning everything....

 

[CJ_London]

My query for this report only has one table- the sql view.

Not sure what this means - if you need further help, please post the sql to your report recordsource