Re: Reports with Date Range - Errors

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

"jwr" <joyrose@xxxxxxxxxxxxx> wrote in message
news:VzuJe.22727$BA5.11050@xxxxxxxxxxxxxxxxxxxxxxxxx
> 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
> "Al Camp" <anon@xxxxxxxx> wrote in message
> news:u%23TzkW1mFHA.4028@xxxxxxxxxxxxxxxxxxxxxxx
>> 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
>>
>> "jwr" <joyrose@xxxxxxxxxxxxx> wrote in message
>> news:6MeJe.19189$jq.11131@xxxxxxxxxxxxxxxxxxxxxxxxx
>> > 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]
>> >
>> >
>> >
>> > "Al Camp" <anon@xxxxxxxx> wrote in message
>> > news:%238BKqvumFHA.1372@xxxxxxxxxxxxxxxxxxxxxxx
>> >> 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
>> >>
>> >>
>> >> "jwr" <joyrose@xxxxxxxxxxxxx> wrote in message
>> >> news:EZ9Je.17171$BA5.13142@xxxxxxxxxxxxxxxxxxxxxxxxx
>> >> > 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
>> >> >
>> >> >
>> >> > "Al Camp" <anon@xxxxxxxx> wrote in message
>> >> > news:usiu$%23rmFHA.3408@xxxxxxxxxxxxxxxxxxxxxxx
>> >> >> 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
>> >> >>
>> >> >> "jwr" <joyrose@xxxxxxxxxxxxx> wrote in message
>> >> >> news:W45Je.7303$%X1.471@xxxxxxxxxxxxxxxxxxxxxxxxx
>> >> >> > Sorry --
>> >> >> > I entered 01/01/05
>> >> >> > No quotes and no # signs.
>> >> >> >
>> >> >> > "Al Camp" <anon@xxxxxxxx> wrote in message
>> >> >> > news:%23BBX$YpmFHA.860@xxxxxxxxxxxxxxxxxxxxxxx
>> >> >> >> 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
>> >> >> >>
>> >> >> >> "jwr" <joyrose@xxxxxxxxxxxxx> wrote in message
>> >> >> >> news:Jt2Je.16746$BA5.307@xxxxxxxxxxxxxxxxxxxxxxxxx
>> >> >> >> >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]
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>>
>
>


.

Relevant Pages

  • Re: sort in report
    ... Your instructions were fine and I followed them correctly. ... report, before the rest of the records with the correct building names. ... Then include the SortThis field in the query. ...
    (microsoft.public.access.reports)
  • RE: Text Box Not Large Enough
    ... Can you post the SQL of the query that is the RecordSource for your report? ... Are you seeing about 255 characters from the memo field? ... On a report that lists the Instructions for a particular PM on a machine ...
    (microsoft.public.access.reports)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)