how can I make a query to show ' inbetween' values?

Hi, I have a quey that shows a record with a beginning and end value (in my case it is a beginning and end hour). I need to make this query display the record for each hour that the record is valid. Below is what I have and what I am trying to acheive:

for instance this is what I have now:
Time Slot: 0100-0200
Spanish 0100-0500

What I need the query to do is to display:
Time Slot: 0100-0200
Spanish 0100-0500
Time Slot: 0200-0300
Spanish 0100-0500
Time Slot: 0300-0400
Spanish 0100-0500
Time Slot: 0400-0500
Spanish 0100-0500

I can't modify the data, it must stay as "Spanish 0100-0500" but I need it to show at each hour that Spanish would be used (i.e. 0100, 0200, 0300 and 0400).

I hope this makes sense!

Not sure where to go from here, any help muchly appreciated!

Sean G.

Sorry, I am slightly confused. So you want a query to tell you if spanish can go with a time frame. Is that what you are asking?
For Example:
TimeSlot = 0200-0300 and if spanish is 0100-0500, then since that time slot fits within spanish, you want spanish to look like this:
Time Slot: 0200-0300
Spanish 0100-0500

and then you want to have some field say:
spanish 0100

Is this what you mean?

theguz

Hi sorry I should have made the question a little clearer!

OK I have a set block of, say, Spanish that runs from 0100 to 0500. What I need the query to do is to display the same record
at each hour that the block is valid for. The reason for doing this is that it will be used in an hourly lookup chart. I have it working so that it shows the record at the beginning of the time slot (i.e 0100) but that is no good if you check the 0200 time slot you wouldn't see the record. I have separated the data so that I have the start hour and the end hour (0100 and 0500 in seperate columns in the query) but what I am trying to do is to get a query to display the same record for the hours in between. so I can display 0100 but I can't seem to find a way of displaying 0200, 0300 and 0400 from the original data.
Looking at what you said, I think you have understood it, but hopefully the above will clarify it (either that or make it worse!). Thanks for the speedy reply!

Sean G.

Here is an idea. Create a table that has a field for only the time blocks. Next to that field have the name be class. Fill in the block times but leave the class column blank. I think what might work is have a form that asks you for the class along with its times. It would then compare the block time, which would already be on the form from the table and see if it the class will work. If it does, have the form save the class in table you created.

Sorry this is the best I could do for now, I dont have enough time to play around too much with the idea but give it a try and I will let you know if I get it to work.

theguz