Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    London
    Posts
    3

    Arrow Unanswered: Crosstab Query - Date Range

    Now, I know this question has been asked so many times before but:

    B]How can I prompt a user for a date range in a crosstab query??[/B]

    I have tried putting it in the select query which it is running off, running a select query over the top, using a form, basing it on two other fields in another table.

    Just not getting anywhere. Any help is much appreciated.

    .
    Me.

  2. #2
    Join Date
    May 2002
    Location
    Chicago
    Posts
    22
    I am running into the same problem, but I don't have users that run my queries, so I don't even bother with figuring this out, I just hard code the date in the query using "Between #00/00/0000# And #00/00/0000#. I don't know if this is what you are looking for, but it works for me.

  3. #3
    Join Date
    May 2002
    Location
    Chicago
    Posts
    22
    Forgot to mention, I do this in the select query that is later used for crosstab.

Posting Permissions

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