Hi there,
It's been a while since I've used Access and I've gone a bit rusty (not that I was a master in the first place aha).
I've created a database to store certificates from our suppliers and I want to create a query that returns the following;
Thanks in advance for any help you can give
Stu
It's been a while since I've used Access and I've gone a bit rusty (not that I was a master in the first place aha).
I've created a database to store certificates from our suppliers and I want to create a query that returns the following;
- Count how many certificates arrived before delivery (<0)
- Count how many certificates arrived after delivery (=>0)
- Count how many certificates are yet to arrive (IsNull)
Thanks in advance for any help you can give
Stu