Access 2007 and Queries with Relationships!
1ddqd
Registered User regular
Registered User regular
I have 2 tables.
[Buckets] has a start and end date that should be treated as a range. Example:
[Month] has a number of records with different dates listed on each row, the exact date an order was placed:
What I want to do is make a query that looks for any order placed within 30 Days and then displays the record that has an order date falling within the 30 Day range. I know it's simple, but I've completely blanked on this!!
[Buckets] has a start and end date that should be treated as a range. Example:
[Month] has a number of records with different dates listed on each row, the exact date an order was placed:
What I want to do is make a query that looks for any order placed within 30 Days and then displays the record that has an order date falling within the 30 Day range. I know it's simple, but I've completely blanked on this!!
1ddqd on
0
Posts
Try using the Date() and DateAdd() functions?