Search results

Yes, but it does not seem to conflict...

I have a functioning crosstab that displays the right records. In the underlying query the records are displayed in the right format. On the form, which has one level of grouping only, the rows in each group do not seem to honor the sort in the underlying query. Any ideas?

Thanks Jon K..Awesome help Thanks for your help

Thanks Jon K..one more question This works well. NOw, how about if for the true part I want all records, for the false part the <> records?

Want to use an immediate if in identifying the criteria for a field in a query. There's a check box called, for example, Box1, on on an open form called FOrm1. From this form we click an option to open form2 with an underlying query called Query1. The criteria for a field called Field1 says...