Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Julio Herrera
- Order by date
-
Query with recursive subquery does not work
Hi SkipVought,- Week_of_sale means the week of the year the reservation was sold, covering 2 years in advance. For example, a stay for 2020-11-14 (yyyy-mm-dd) sold on 2019-10-10 will have Week_of_sale = 41. Same stay sold on 2020-05-05 will have Week_of_sale = 70. That is why Week_of_sale...- Julio Herrera
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Query with recursive subquery does not work
Hello, I am a new member of the Forum, and I would be grateful if someone could help me out. I have a table (Reservation_line) with 3 meaningful columns (for this question): Date_of_stay, Week_of_sale, Number_of_rooms. This table has data of hotel reservations for somes dates of two years and...- Julio Herrera
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
