"No Record Found" Message

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

Guest

The previous owner of this database created a query that would allow people
to choose a "Unit" and a "Region (this can be entered or left blank for all
regions)." This would then create a query based on what was entered. This
has always up until about a week ago. It works for all units except for one,
when I enter the unit and leave "region" blank, I get a "No Records Found"
message when there really are records. If I enter the unit and a region, it
works.

Hard to explain, any help?
 
Keri

A look at the query's SQL statement might provide a clue...

Regards

Jeff Boyce
<Office/Access MVP>
 
Back
Top