Newbie Question about Date Ranges
Hi, I'm relatively new at this but I just want to create a simple function in my database and I'm struggling when it comes to which way would be the best way to go about it.
I have 2 tables - Customers and Bookings. 'Bookings' has a date field.
In the Customers table there are 2 fields (among others) called Winter and Summer. If the booking date is in a winter date range I want the Winter field to be ticked or say 'Yes' or something, and the same for the Summer.
The tables are related, I'm just new when it comes to scripts and calculations etc...
Am I right in thinking that the Winter and Summer fields should have auto-enter calculations which would say 'Yes' when a script finds a date in the date range?
Thanks for your help.