Search results

I am starting to learn to use form is access and have created an unbound form because I beleive you have more control over table records. My question is, how do I validate fields on my form first and then once all validation are correct and no errors appear it saves the record? This is currently...

I am making a database for hockey teams and games. How can I create a validation rule so that one team cannot play itself and that a team can not play the same team more than once a day? I have tried: IIf([homeTeamId]=[awayTeamId]) But this is not working. Any help would be appreciated. Thanks:)

I am building a query and want to show only the checkbox's that have been checked. What kind of validation rule/formula can I make so I can create my own column title and then show the name of the checkbox's checked? Here is a picture of what it currently looks like: Instead of having all the...