hitchhiker
Registered User.
- Local time
- Today, 14:02
- Joined
- Apr 15, 2003
- Messages
- 11
I have created a database which is responsible for turning out several reports at my office. One of the tables in this database lists all products that have had a particular violation, what the violation was and the date of the violation. What this report needs to show is whether or not any given product had a violation during a particular month or not.
Can I write an iif statement that will return a '1' or a '0' based on whether there was a violation during a particular time period?
If so could you please provide an example of the syntax...
Thanks for the help.
Can I write an iif statement that will return a '1' or a '0' based on whether there was a violation during a particular time period?
If so could you please provide an example of the syntax...
Thanks for the help.