if statment

[ismailkhannasar]

i like to get all records of those grant which is approved
Not Rejected Grant

how to make if statmenet in Access

[alansidman]

See this link
http://www.techonthenet.com/access/f...vanced/iif.php

[ismailkhannasar]

See this link
http://www.techonthenet.com/access/f...vanced/iif.php

where to write these type of code i m new in access , thanks

[alansidman]

These can be written in Queries, Forms or reports depending on your particular situation. The information you have provided is to vague to give you a specific answer. If you have specific questions relating to your database, please post them and we will do our best to answer with specific solutions. In the meantime, here is a 100 page tutorial on creating and building Access databases that will help you to get started on the right track.

http://www.accessmvp.com/strive4peace/