Hi all,
bit of an odd one...
I have 2 tables in a query. One has dates, which aren't always sequential, the other has the default values required where the table with dates doesn't have a matching record...
I need to create a field that generates a record for every date between 2 dates. I will then have a calculated field which will be set to a specified value which is in the table containing a matching date, failing that, it will match another field within the second table.
I'm fine with the calculated field, but I'm struggling with how to force a record for every day between the from and to date, other than creating a single table with a bunch of sequential numbers!
Any suggestions/help appreciated.
bit of an odd one...
I have 2 tables in a query. One has dates, which aren't always sequential, the other has the default values required where the table with dates doesn't have a matching record...
I need to create a field that generates a record for every date between 2 dates. I will then have a calculated field which will be set to a specified value which is in the table containing a matching date, failing that, it will match another field within the second table.
I'm fine with the calculated field, but I'm struggling with how to force a record for every day between the from and to date, other than creating a single table with a bunch of sequential numbers!
Any suggestions/help appreciated.