The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
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?