Hey every1, thanks in advance for taking the time to read this.
This is my problem:
I'm running a project with behind it an acces database.
What i'm trying to do is, i want a report that filters a tabel (with around
25000 records). But it filters at 2 places, let's say name and age.
So i want everyone with the name "smith" and age "18".
But when i select expert and i give the solution, so (tbl_clients.name) =
"Smith" and (tbl_clients.age) = "18" , it works just fine.
But here it comes, i'm giving the user full controle and i say in a form
that he can just enter whatever he wants in name and age, and i save it to
a table in the database. now i want to filter with the value's that are
entered in that table. so normally it has to be (tbl_clients.name) =
(tbl_Print.name) and (tbl_clients.age) = (tbl_Print.age) , but this doesn't
work. when i load the report, it just give's me a blank report.
I've tried this with expert in the report, but i can't find an other way.
I've tried to be as clear as possible, if there is something that i've left
out or so, please send something and i will correct it.
Again thanks in advance
Andy Van Steenbergen