filtered search using dates in query

  • Thread starter Thread starter Dennis Cook
  • Start date Start date
D

Dennis Cook

hi,
Likely not a sofisticated problem but causing lots of
grief. Using Access 97 (required by application).
Created select query; DATE field criteria: Between [enter
start date] And [enter end date]. [enter start date],
[enter end date] (Date type) both listed in Query
Parameters. Created crosstab query from the select Q
(same fields as select including element_name (group by,
column Heading), data (first, value). I also added the 2
date entry requests to Query-Parameters in cross tab query.

REPORT: requests that I enter 'start', 'end' dates
whenever I enter design or display the field list.
Report doesn't run: "The MS Jet database engine does not
recognize '[enter start date]' as a valid field name or
expression."
The query runs fine. One key table field (not the date
field I'm searching on ~ 50,000 records).
How do I fix report? Can I use different temp indexes on
my search field to speed up search?
Any advice appreciated. Thanks.
dennis cook
 
update: The report must use the x-tab qry as the chemical
elements are named intead of the 'data' field in the
select qry. I created a rpt using the select qry: works
without constantly asking for [start], [end] dates every
time I do anything. It just doesn't separate the 'data'
field into individual chemical elements. Problem exists
with the report from the x-tab qry.
- dennis
 
If you are still having a problem, use text boxes on a form for the
parameters rather than a prompting parameter.

--
Duane Hookom
MS Access MVP


dennis said:
update: The report must use the x-tab qry as the chemical
elements are named intead of the 'data' field in the
select qry. I created a rpt using the select qry: works
without constantly asking for [start], [end] dates every
time I do anything. It just doesn't separate the 'data'
field into individual chemical elements. Problem exists
with the report from the x-tab qry.
- dennis
-----Original Message-----
hi,
Likely not a sofisticated problem but causing lots of
grief. Using Access 97 (required by application).
Created select query; DATE field criteria: Between [enter
start date] And [enter end date]. [enter start date],
[enter end date] (Date type) both listed in Query
Parameters. Created crosstab query from the select Q
(same fields as select including element_name (group by,
column Heading), data (first, value). I also added the 2
date entry requests to Query-Parameters in cross tab query.

REPORT: requests that I enter 'start', 'end' dates
whenever I enter design or display the field list.
Report doesn't run: "The MS Jet database engine does not
recognize '[enter start date]' as a valid field name or
expression."
The query runs fine. One key table field (not the date
field I'm searching on ~ 50,000 records).
How do I fix report? Can I use different temp indexes on
my search field to speed up search?
Any advice appreciated. Thanks.
dennis cook
.
Click to expand...
Click to expand...
 
Back
Top