Forum Discussion
Solved
Data between two dates crossing over months
Hi. I have booking dates (UK format) and need to produce a report for number of days per month for these bookings. Eg: 01/01/2020 - 04/01/2020 = 4 days 23/1/2020 - 29/1/2020 = 7 days; total f...
i import your query to a table.
i also made some tables (ending with Z), and some "related" queries (numbered according to the sequence i made them).
use the form to show the report.
i import your query to a table.
i also made some tables (ending with Z), and some "related" queries (numbered according to the sequence i made them).
use the form to show the report.
Thanks @arnel_gpp. It took me a little while to get my head around your workings (I don't use anything that I don't fully understand) but I've got it now and the solution works. Thank you.