Infiltrator64
Board Regular
- Joined
- Dec 19, 2004
- Messages
- 63
I have a query that select records based on a range of dates for the case close. I use a parameter to prompt for a Begin Date and an End date. I then want to get the begin and end date values for the query from a table called Date Range. It contains two columns, Begin Date and End Date.
I can get this query to work right if I point the parameters in the query criteria to a form that have Begin Date and End Date fields linked to the Date Range table but I can't get it to recognize the values when I have the query criteria parameter look at the date range table to get these values.
I am using the following criteria in my close_date column of my query.
Between [Date Range]![Start Date] And [Date Range]![End Date]
When I try to get these values from the Date Range table it still prompts me for dates. I'm wondering if I need to specify a row some how? The date range table only contains one begin and one end date value.
Can someone help me figure this out?
I can get this query to work right if I point the parameters in the query criteria to a form that have Begin Date and End Date fields linked to the Date Range table but I can't get it to recognize the values when I have the query criteria parameter look at the date range table to get these values.
I am using the following criteria in my close_date column of my query.
Between [Date Range]![Start Date] And [Date Range]![End Date]
When I try to get these values from the Date Range table it still prompts me for dates. I'm wondering if I need to specify a row some how? The date range table only contains one begin and one end date value.
Can someone help me figure this out?