I'm just starting to play with access with the aim of using it with frontpage on website, but rather than following tutorials I was trying it out with a table i would be looking to use online.
My first question is I have two fields with home team & away team in them but I want to do a query that will list both the home and away fixtures for a selected team. So I need to query two fields at the same time, I've used the [Select Team ?] as a criteria in one field but don't know how to do two fields together.
My second questin is can you add drop down menu's for the team selection.
Thanks in Advance
My first question is I have two fields with home team & away team in them but I want to do a query that will list both the home and away fixtures for a selected team. So I need to query two fields at the same time, I've used the [Select Team ?] as a criteria in one field but don't know how to do two fields together.
My second questin is can you add drop down menu's for the team selection.
Thanks in Advance