Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    2

    Unhappy Unanswered: Crosstab Query Error please help!

    Let me start out by saying I am the most basic user on the planet. Everything I have read allready has mostly just confused me.

    I am trying to have a Report that I built from a Crosstab Query open between specified dates.

    I have.....

    Entered in the Criteria under Date:

    Between "[Forms]![Which Date?]![Start Date]" And "[Forms]![Which Date?]![Finish Date]"

    Entered in the Paramaters:

    [Forms]![Which Date?]![Start Date] with a data type of Date/Time

    [Forms]![Which Date?]![Finish Date] with a data type of Date/Time

    Built a form (called Which Date?) with:

    2 unbound text boxes called Start Date and Finish Date

    I am getting an error message that says:

    This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variable.

    What is that about?

    Other details I should mention

    -The Crosstab Query is built from another query that is built on a couple of tables.

    -I really am not up on database lingo, so please talk down to me.

    Thanks

    Aleasha

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Hi Alesha, and welcome to the forum,......

    try your phrase without the quotes ("), that should work

    Code:
    Between [Forms]![Which Date?]![Start Date] And [Forms]![Which Date?]![Finish Date]
    if that fails consider explicitly telling the query to excpet a date value
    Code:
    Between cdate([Forms]![Which Date?]![Start Date]) And cdate([Forms]![Which Date?]![Finish Date])
    if that fails consider putting the date between hash symbols (#).

    However I'm pretty certain that removing the quotes will do the job.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2006
    Posts
    2

    Smile Thanks, but......

    Thanks, it did work, but for some reason I get four promts. (2 for start Date and 2 for finish date)

    Any idea why?

    Aleasha

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •