Hi! As mentioned in the title, I need help with a query. Here's the info.
I have a database set up and one of my columns is 'Department'...i need to find out how many people are in each department but between a certain date. So basically I've started a query as seen in the image attached (1) and when i run it, it comes up with the information I want (2) but it doesnt have the date sorted. So when I add in the date in the query (3) it comes back listing them separately when I run it (4).
1.
2.
3.
4.
I hope I have given enough info. I just want it to say - Business department, 2 records (but only showing records only after the 1st July 2016). On my first attempt without a date field, it was showing the number in each department in total....over the period of the last year!
Thanks in advance!
Lynne