Hi, I tried to search for my answer, but couldn't seem to find it. If this question has been answered before, I'd appreciate it if anyone could point me to the correct thread.
I have a database to store projects. Each project is assigned a person, Bob, Dave or George. They are radio buttons on the add record form. There can only be 1 choice.
I have a link created to search each person's projects.
I can search for all of Bob's projects; I can search for all of Daves and even all of Georges without any problem. My link use &user=George for example to create the search.
I can even use &user=>Bob and the search returns all of Daves AND all of Georges. The same holds for &user=<George I get Bob AND Dave.
What I want to search is all of Bob AND George. I can't seem to find the correct syntax for this. &user=<>Dave doens't work. &user=Bob&user=George doesn't work either.
Any ideas?
Thanks in advance for your time.
I have a database to store projects. Each project is assigned a person, Bob, Dave or George. They are radio buttons on the add record form. There can only be 1 choice.
I have a link created to search each person's projects.
I can search for all of Bob's projects; I can search for all of Daves and even all of Georges without any problem. My link use &user=George for example to create the search.
I can even use &user=>Bob and the search returns all of Daves AND all of Georges. The same holds for &user=<George I get Bob AND Dave.
What I want to search is all of Bob AND George. I can't seem to find the correct syntax for this. &user=<>Dave doens't work. &user=Bob&user=George doesn't work either.
Any ideas?
Thanks in advance for your time.