I have 2 tables. Volunteer and Vacancy. Both have the same age range lookup. There are 4 criteria, Any, Under 13, 13-15 and 13-19. I have created a match query by first creating the Volunteer Query with VolID, Name, AgeID and a Vacancy Query with VacID, Title, AgeID. I then created another query based on these two queries using AgeID to match by. It works fine if the IDs are the same but what I really want it to do is if the Age Range is Any (AgeID 1) I want it to match with any of the other records (13-15 etc) and not just with the Any. Does this make sense? I guess I need to get into the SQL for the Query but I don't know how or what to do.
Can anyone help please. Learn something new every day *:->*
Can anyone help please. Learn something new every day *:->*