steve.mccall1
New member
- Local time
- Today, 21:33
- Joined
- Mar 4, 2008
- Messages
- 5
Hi all,
I'm a little stuck with what seems to be (to me anyway) quite a complicated query.
I need to create a report that shows the number of items of each different type per month within two dates selected on the initial access form. e.g.
I'm assuming I need to create a function to identify which month the date lies in and return a true / false which I can count but I'm not quite sure how to do it.
Any help would be greatly appreciated!
Steve
I'm a little stuck with what seems to be (to me anyway) quite a complicated query.
I need to create a report that shows the number of items of each different type per month within two dates selected on the initial access form. e.g.
Code:
TYPE 10/07 11/07 12/07 01/08
Dog 1 4 5 6
Cat 6 1 5 7
I'm assuming I need to create a function to identify which month the date lies in and return a true / false which I can count but I'm not quite sure how to do it.
Any help would be greatly appreciated!
Steve