Search results

my god, you're a genius. thanks so much for helping me, i really appreciate it. I'm learning . . . slowly but surely.

i isolated the form, report, and two tables, and changed the data (solely for confidentiality) - the report still needs some work, as in, displaying the names of the witnesses selected at top, which i just haven't done yet. i'm just trying to get it to display the right records. again, if...

I tried adding the "is null" part, but when I did that it returned every record (aka, didn't filter anything) - It makes sense to me, but is not working, so i'm doing something wrong.

thanks for you response adam. I tried your code and it didn't return any results. Then i read the link you suggested and added some stuff and tried this code: SELECT * FROM [yourTable] WHERE ([witness_1] = forms!frmrunreports!witness_1 OR [witness_1] = forms!frmrunreports!witness_2 Or...

alright, say i want a report that will only disply records that have john, sam, bill, and rachel as witnesses. here are a couple example records: [witness_1]-------[witness_2]-------[witness_3]-----[witness_4]---[date] john -------------sam -------------rachel ---------- bill...

i've got a table, [datalist] that contains four fields called, [witness_1],[witness_2],[witness_3],[witness_4]. I've also got a table called [witnesses] that only has one field called [witness] which is simply a list of all witnesses. I've got a form called [frmrunreports] that currently has...