Please Help! Very Stuck!

[neileg]

At the moment, the database query which Rich kindly did works brilliantly, but only filters the Course Start box, meaning I can create a list of arrivals on any given Fri-Mon, but not the leavers. It's that latter bit I need to add.
In the QBE grid enter exactly the same expression in the end date column as you have in the start date column but ensure it is on the next line down so it becomes an OR. Thus your query will pull records where the start or the end date falls between your parameters.

Another small point is that Rich's form filters correctly, but opens the filtered form in Add/Edit mode. It's purely a cosmetic concern, but how do I alter it to open in Read Only mode?
Change the form properties

 

[simongallop]

Open the form Coredata1 in design view.

On the toolbar click View / Properties

On the recordsource section at the far right is a small button with 3 dots (...). Click it

A query builder view will show

In the 5th column (Course Start) you will see some code in the criteria section. Highlight the whole string and copy

goto the 6th column (Course End) and paste it IN THE NEXT ROW DOWN (on the far left the row is titled 'Or:')

HTH

 

[simongallop]

Oops posted at the same time!

 

[Tezcatlipoca]

It works! After four pages, two uploads and repeated confusion on my part, the monster I have created lives!!!!
thanks so much to everyone who pitched in with advice. I now have a database that works exactly as it's supposed to. Virtual hugs all round