Unanswered: Merging two columns into one and therefore doubling rows
So, I feel that I've missed something here but here goes...
If i have a table with two columns, how can I (using a query) pull those together to appear to be the same field... ?
A fuller explanation of what I'm doing.... (it's not imperative that you read this bit!)
I have a system that monitors kids coming in and out of a nursery. The childrens "shifts" have a "start time" and "end time" already stored in data, and every other bit of the system likes these to be separate fields.
However I need to calculate how many staff are required at any one time. So my plan is to combine these start/end times into one field as above with the second column telling me if a child is going in/out. therefore using these piece of data i can iterate through the data and for each start/end point calculate how many children there will be.
Any other suggestions to solve this would be welcome. No doubt something will come to me if I just stop thinking about it.!
That was my initial idea for doing this, but I was thinking rather than doing unnecessary calculations based on every 30 minute period, I should do that calculations based solely on when the number of children change throughout the day.
I think I may well use this 30 minute interval method unless I have a brainwave in my sleep tonight.