validation

[pramodakumara]

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.
pramoda

[nav33n]

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

[zandiago]

Welcome!

[Sulley's Boo]

Try this :?:

SELECT Table1.ddate
FROM Table1
WHERE (((Format([ddate],"dd/mm")) <> '26/01' AND (Format([ddate],"dd/mm")) <> '15/08'));