Filter problem

[daniel aristidou]

hi i have already posted another post of this but it was not answered. So i have tried rewording my problem.

Is it possible to create a way of searching throgh all the records(tasks) and making a table apear showing incompleted things? ie records which have a null value for a [date finished] feild. The catch is that i have many tables with incompleted tasks.All of the tables however do have exactly the same feilds so this simplifies it,i think.
I use access 07 ,
If people tell me to try vb code please be specific on where to insert it since in previous posts people have not and have had to spend along time waiting for replies to where to place it.

Thanks for help in advance , !!! (`~_~`)

[MikeTheBike]

hi i have already posted another post of this but it was not answered. So i have tried rewording my problem.

Is it possible to create a way of searching throgh all the records(tasks) and making a table apear showing incompleted things? ie records which have a null value for a [date finished] feild. The catch is that i have many tables with incompleted tasks.All of the tables however do have exactly the same feilds so this simplifies it,i think.
I use access 07 ,
If people tell me to try vb code please be specific on where to insert it since in previous posts people have not and have had to spend along time waiting for replies to where to place it.

Thanks for help in advance , !!! (`~_~`)

Hi
If all the tables have the same fields then ceate a union query to stich all the table together and filter it (WHERE DateFieldName Is Null).
This will need doing in SQL view

You can then use the query as you would a table.

Sorry have to go, but if more info need, please post back.

MTB

[daniel aristidou]

Thanks this is a help , ill look up union on microsoft office and post if i have any problems....Thanks alot