N
northernMONKEY
Guest
Hi
I've got a query which lists animal with ages between 0 and 30 months. What I want to do is when the access database loads, list all those animals that are between 26 - 30 months old (obviously the query i currently have can be easily adapted. This should not be displayed if no animals are in this age category and should just continue to the main menu. Does anyone know how to do this?
regards
Chris
I've got a query which lists animal with ages between 0 and 30 months. What I want to do is when the access database loads, list all those animals that are between 26 - 30 months old (obviously the query i currently have can be easily adapted. This should not be displayed if no animals are in this age category and should just continue to the main menu. Does anyone know how to do this?
regards
Chris