how to filter data that is displayed in a report from a query

[kee2ka4]

Hey peeps,

I have data that is displayed in a report from a query. How can I filter that data with a conditional statement? Is this possible in access? So for example, my record has got a "Detail section" that has two textboxes, these two textboxes displays names of employee. So I want apply a condition on the first textbox to only display employee records where deletedFlag == 1 and in the second textbox, display employee records where deletedFlag == 0.

Can anyone plz guide me on how to do this?

Thanks,
Ket

 

[vbaInet]

If this is going to be a static query then put that in the query's Criteria row under each of the relevant fields:

=1

 

[kee2ka4]

If this is going to be a static query then put that in the query's Criteria row under each of the relevant fields:

=1

Can you give an example, I am not sure how to put it in a query's Criteria row. Isn't there a way to apply the conditions to the text box in the details section of the report? So say the query give me 4 records: Tom, Bob, Bill and Jack and Jack has deleted flag = 1 and the rest has 0, then I want the report to display the following:

Current Employee Past Employee
============= ===========
Tom .................. Jack
Bob
Bill

Hope I am making sense!

Thanks,
Ket

 

[vbaInet]

If you want to run those two reports in parallel it would depend upon how your tables are related? Have you got a pic of the relationships?