Hi,
I'm running a query that needs to pull dates from another table as its criteria.
As in, I have 2 fields in another table: [start] and [end]
I go into the query and on the date criteria: "Between [date range]![startdate] And [date range]![enddate]
I run this, and it never ends...Access usually freezes. I checked the file and it looks fine, formats are good...no issues that I can see.
If I type the dates manually, 'between ##### and #####', the same dates listed as startdate & enddate.....it runs fine and quick.
I did another test in which I queried off the date range table and had it list out all dates in between in a new table. Then I linked my main query to this table that listed all of the dates in range...Same issue
I'm not understanding why if I manually type dates it takes 10 seconds it seems, but if I do it with fields from another table (even though the table only has 2 fields and 1 row)....it crashes.
help?
I'm running a query that needs to pull dates from another table as its criteria.
As in, I have 2 fields in another table: [start] and [end]
I go into the query and on the date criteria: "Between [date range]![startdate] And [date range]![enddate]
I run this, and it never ends...Access usually freezes. I checked the file and it looks fine, formats are good...no issues that I can see.
If I type the dates manually, 'between ##### and #####', the same dates listed as startdate & enddate.....it runs fine and quick.
I did another test in which I queried off the date range table and had it list out all dates in between in a new table. Then I linked my main query to this table that listed all of the dates in range...Same issue
I'm not understanding why if I manually type dates it takes 10 seconds it seems, but if I do it with fields from another table (even though the table only has 2 fields and 1 row)....it crashes.
help?