• Are you calling a stored Proc to query the DB from your form? Or is it Raw SQL?

    If Stored Proc you can do it quite easily with an IF Statement.

    Either you can use Date as the criterea for determining which table to look at or you can use @@rowcount.

    Select from small table, Check @@rowcount. If that is 0, then look at the big table.

    -Roy