Enter Find Mode
Set Field (yourtable::start_date; "<= G_date")
New Record/Request // sets up an OR find
Set Field (yourtable::end_date; ">= G-Date")
my bad...misread your post
ignore the 'add new request'
and syntax for set field is (yourtable::start_date;"<=" & yourtable::g_date)
Thank you for taking the time to help. That fixed it.