Ive posted this type of question before but, I still failed to solve it despite support from here.
So - here we go again
I have a table with 12 "from" "to" dates in. These are more or less monthly periods that I have to report data on.
I need to be able to use these dates in a number of differing reports/queries.
example: to find people by quantity who started training between each of the 12 period dates. Its seems simple enough but for the life of me I can't get there at all. As much as I hate to admit it I suppose I need an example to follow so that I can beat this issue. I'm not a SQL guy at all - never needed it (until now I think).
Sorry to ask this again but Ive done the whole DB and have had to resort to 12 queries that is interigated by a 13th to at least start the process.
a very stressed out Gareth (white hair not optional)
Just to clarify what you are trying to do: You want to find out how many people started training between the from and to dates or you want to find the names of people that started training between those two dates?
Either case, I attached a db that contains 2 tables: datefromto and names
There are also 2 queries: People (this lists the names of the people within each date group) and CountofPeople (this counts the people in each date group).
I hope this answers your question.
If not, please be more specific and I will try to help.
As you put in the example (which was pretty smack on the money)
The search will be "equal to or greater than FROMDATE and equal to or less than TO DATE".
Ill be using this query to
find quantities of people starting on training / leaving training.
what qualifications were achieved ("equal to or greater than FROMDATE and equal to or less than TO DATE")
failed qualifications, resit qualifications etc etc.