View Single Post
Old 06-04-2019, 12:14 PM   #15
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,383
Thanks: 434
Thanked 804 Times in 779 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: List dates between date range

I do not think you can do it with a query as you have coded it.?
Normally there would be the dates themselves in the table and then you specify the start and end.
As it stands now, you just have the range of dates in the table you are trying to append from.?

Code:
INSERT INTO tblDate ( TheDate )
SELECT tblDate.TheDate
FROM tblDate, Table1
WHERE (((tblDate.TheDate) Between [Table1].[StartDate] And [Table1].[EndDate]));
The experts will know a better way. In fact didn't TheDBguy offer a method?
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote