i wanted to restrict the national holidays in validation rule (msaccess),i could restict one
holiday ex:-15-aug every year by applying ([hdate])<>15 and month([hdate])<>"aug"
but when i tried to enter two holidays ex:-([hdate])<>15 and month([hdate])<>"aug" AND([hdate])<>26 and month([hdate])<>"jan",it did not work.Help please.

Welcome to Daniweb! Please post your question in msaccess forum.


Try this :?:

SELECT Table1.ddate
FROM Table1
WHERE (((Format([ddate],"dd/mm")) <> '26/01' AND (Format([ddate],"dd/mm")) <> '15/08'));
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.