Criteria Form Question

  • Thread starter Thread starter Russ Kroeger
  • Start date Start date
R

Russ Kroeger

I have a report that will uses a criteria form that uses text boxes to enter
dates to bracket the report that gets generated. Everything works as it
should except the report excludes the beginning date entered in the text box
so that data is missing on the report. However the data for the ending date
is always included. If I forego the criteria form and use the query the
report is generated from the data reports correctly leading me to think I
have the expression in the query correct. Has anyone had any experience
with this? I'm stumped.
 
I also should add that the report doesn't work if I use the same date for
beginning and end. So if I want a report for one day all I get is "error" on
the report. Thanks
 
Make sure you have the right operators in the criteria, and that you do not
have a time in the field:
=[forms]![MyForm]![FirstDate] and <=[forms]![MyForm]![LastDate]
Click to expand...
or
between [forms]![MyForm]![FirstDate] and [forms]![MyForm]![LastDate]
 
I checked the criteria as it is written in the query and it is the same as
yours. The query works the way it is supposed to but the form that was set
up with the text boxes for the criteria doesn't. It always drops the
starting date's data from the report.
jl5000 said:
Make sure you have the right operators in the criteria, and that you do
not
have a time in the field:
=[forms]![MyForm]![FirstDate] and <=[forms]![MyForm]![LastDate]
Click to expand...
or
between [forms]![MyForm]![FirstDate] and [forms]![MyForm]![LastDate]


Russ Kroeger said:
I also should add that the report doesn't work if I use the same date for
beginning and end. So if I want a report for one day all I get is "error"
on
the report. Thanks
Click to expand...
Click to expand...
 
Which criteria do you have in your query?
= or between
Click to expand...

Russ Kroeger said:
I checked the criteria as it is written in the query and it is the same as
yours. The query works the way it is supposed to but the form that was set
up with the text boxes for the criteria doesn't. It always drops the
starting date's data from the report.
jl5000 said:
Make sure you have the right operators in the criteria, and that you do
not
have a time in the field:
=[forms]![MyForm]![FirstDate] and <=[forms]![MyForm]![LastDate]
Click to expand...
or
between [forms]![MyForm]![FirstDate] and [forms]![MyForm]![LastDate]


Russ Kroeger said:
I also should add that the report doesn't work if I use the same date for
beginning and end. So if I want a report for one day all I get is "error"
on
the report. Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top