I'm developing in Access 2002 a mdb for our hockey club that is a scheduler for teams and practice/game times. I need a query that will find the team name in multiple columns.
For instance....Team Name "Rangers" can be scheduled on a date and time where they are the only team on the ice that day. Their team name will appear in a column called Team-Full, which designates they are the only team on the ice that day.
On other dates, teams will share the ice, meaning Team Name Rangers will appear in a column called Team 1 while the ice will be shared with Team Name Ducks. So the user can now tell that on that date and time, two teams are sharing the ice for practice.
The flat file look like this:
Day date time type team full team 1 team 2
Saturday 11/01/02 6:30 AM full Rangers
Sunday 11/02/03 7:45 am split Rangers Ducks
So, I'd like write a query that 1. prompts the user for the team name 2. searches all columns....Full, Team 1 and Team 2 and displays the results so that the user knows all dates and times that a particular team will appear on the schedule.
Thanks in advance for your help
For instance....Team Name "Rangers" can be scheduled on a date and time where they are the only team on the ice that day. Their team name will appear in a column called Team-Full, which designates they are the only team on the ice that day.
On other dates, teams will share the ice, meaning Team Name Rangers will appear in a column called Team 1 while the ice will be shared with Team Name Ducks. So the user can now tell that on that date and time, two teams are sharing the ice for practice.
The flat file look like this:
Day date time type team full team 1 team 2
Saturday 11/01/02 6:30 AM full Rangers
Sunday 11/02/03 7:45 am split Rangers Ducks
So, I'd like write a query that 1. prompts the user for the team name 2. searches all columns....Full, Team 1 and Team 2 and displays the results so that the user knows all dates and times that a particular team will appear on the schedule.
Thanks in advance for your help