jwr,
I found the Order Entry Template. I had no data, but I was able to test
the Report Date Range form, and the Sales By Customer report.
Even though the report came back with no data, the date entry worked
fine. I used several legitimate date ranges. I even entered illegitimate
dates like 88/88/88, but I got an appropriate "Invalid entry" error... not a
"too complicated" error.
If you have not changed the Report Date Range form in any way, or the
Sales By Customer report, and you really are enetering legitimate dates,
then I have no idea where the problem could be.
If you have made any changes *at all* to either the form or report, then
delete them, create a seperate new OrderEntry MDB, and import the form and
report from there into your MDB. That would put you back to a pristine
Report Date Range form, and a Sales By Customer report.
At this point, that's all I can suggest.
Please feel free to create a totally new post with this question. This
one is getting a bit "buried."
Perhaps someone else may have some new ideas.
hth
Al Camp
jwr said:
My apologies -- I must have stopped reading after your question about the
Access version.
I changed the query criteria to read as you asked.
I saved info and attempted to open the form (I selected the report which
brought up the form with parameters).
I entered valid dates.
I attempted to preview and got error message -- "typed incorrectly or too
complicated to evaluate.".
I then opened the report in design view, selected properties, chose the
SQL
query, determined that it was changed to your criteria. I attempted to
run
the query and got the same message.
I did attempt to use control + F6, but nothing happened.
Did I misunderstand you?
Thanks
Al Camp said:
jwr,
OK on 2003, I'll try to find it, but... what about my instructions,
and
other questions?
You were supposed to do some query testing for me. What happened?
If we're going to solve your problem , you need to read my posts, follow
the instructions, and get back to me with what happened... in detail.
No new questions until we solve the first one!
Al camp
This is an Order Entry Template -- I am using Access 2003, but it was
on
2000 also.
Another question for you -- I have created a query and then a report from
that query. Within the query are numerous tables. When I, for instance,
want to see the payments made against an invoice, I get a payment for each
line item rather than a total amount paid by date. should I be
creating
individual queries and then one query to combine all of the individual
queries for my report? Thank you so much for your assistance and for your
patience with me. I am very short on knowledge of access.
Joy
OK...
What version of Access are you running? I found an Orders database in
Access97, but I don't see the form or report you describe. Is Orders
a
sample or template?
Let's determine if just the query will run clean. If so, then it's
the
report that has a problem.
Your query criteria...
=[forms]![Report Date Range]![Beginning Order Date] And
<=[forms]![Report Date Range]![Ending Order Date]
Just for now, use my criteria...
Between Forms![Report Date Range]![Beginning Order Date] and
Forms![Report
Date Range]![Ending Order Date]
Now...
Open your form, and enter 2 legitimate dates for the range, and
leave
the
form open.
Use Ctrl-F6 to access the other database objects and open the
report in Design view. Go into query design grid for the query
behind
the
report, and run it (while your form is still open).
Here's the big question... does the query run correctly?
Does it return the appropriate records you want?
It should NOT prompt for any parameters... it should automatically get
them
from the open form.
hth
Al Camp
Yes, the Report Date Range form asks for Beginning and Ending Order
Date.
The criteria below is against Order Date:
=[forms]![Report Date Range]![Beginning Order Date] And
<=[forms]![Report
Date Range]![Ending Order Date]
OK, we're getting there. I don't have that database so we'll
have
to
wing
it.
The form that calls the report should be named [Report Date Range],
and
it
should have 2 DateType fields on it called [Beginning Order Date] and
another named [Ending Order Date]... where you enter the two dates
required
for the report
Do that for a first step... because that's what the report is looking
for.
Now...
The properties of the report ties into a query with the beginning
and
ending
date as criteria.
I need to know what that criteria is... exactly as you see it in
the
query,
and what field it is entered against. (Order Date maybe?) Here's what
I
would expect to see...
Between Forms![Report Date Range]![Beginning Order Date] and
Forms![Report
Date Range]![Ending Order Date]
Let's try that, and see where we are afterwards.
Hang in...
hth
Al Camp
Al -- This was created when I used the Order Database with
Access.
This
is
what I see:
Report Header: Sales by Customer
Beneath Sales by customer is a box with the following
information:
="For Orders Rec'd Between: " & forms![Report Date Range]![Beginning
Order
Date] & " and " & forms![Report Date Range]![Ending Order Date]
When I attempt to run the report, I get a box that "pops up" asking
for
the
beginning and ending dates.
I enter 1/01/05 or 01/01/05 and get the error message.
The properties of that text box are: Text box with control
source
being
the
information I listed above.
The properties of the report ties into a query with the beginning
and
ending
date as criteria.
I am not sure what you mean by "Are the parameters the criteria for
a
legitimate Date/Time field on your
report?"
Let me know if I did not answer your questions.
thanks
Please provide a bit more info...
Is you query a parameter query?
If so, what is the parameter statement?
(ex. Between [Enter Start Date] And [Enter Stop Date])
Are the parameters the criteria for a legitimate Date/Time
field
on
your
report?
What is the field name and type?
Al Camp
Sorry --
I entered 01/01/05
No quotes and no # signs.
jwr,
It would have been helpful had you indicated what you
keyed
in
(exactly)
in response to the prompt...
I'm assuming your entering a Date parameter against a Date
field
using
normal date formatting.
Normally, dates are entered as mm/dd/yy
01/01/05
or, you can drop the zeros
1/1/05
No " quotes, no # poundsigns.
hth
Al Camp
I am using Access Orders Database. On the Orders by
Customer
Report
(and
other reports) when I attempt to preview, a box pops up asking
for
a
date
range. When I first input the date range I got a message that
read -
"Incorrect format." I changed text box properties to short
date.
Then
I
got the message -- "Typed incorrectly or too complex to
evaluate."
I
changed the format back to blank as it was originally. I
am
still
getting
the message typed incorrectly, etc. and am unable to
preview
the
report.
="For Orders Rec'd Between: " & forms![Report Date
Range]![Beginning
Order
Date] & " and " & forms![Report Date Range]![Ending Order
Date]
