1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Reports & Forms Questions

Discussion in 'Business Applications' started by Kammmie, Sep 2, 2004.

Thread Status:
Not open for further replies.
  1. Kammmie

    Kammmie Thread Starter

    Joined:
    Aug 14, 2001
    Messages:
    132
    A few people have tried helping me with this and maybe I am just missing something .......

    I have a report that prints out our orders by date. I did a query so that I can enter the date range I want. How when I click on the report do I get the box to come up that asks for the date range without having to go in and change the query every time?

    Thanks,
    Kammmie
     
  2. jmosmith

    jmosmith

    Joined:
    Aug 10, 2004
    Messages:
    6,091
    Have you hard-coded the date range in the Query, and do you have to re-enter it as a hard-code to change it?

    Because if you input the "Criteria" as follows:
    >=[Enter mm/dd/yyyy of date to be GREATER than or EQUAL to]

    then both the Query and the Report that runs from it should prompt you for the new date each time?

    Now I don't think all of that in the braces "[ ]" will fit, it has a limit, and you'll want to indicate the correct date format for your records.

    Otherwise, you'll need to add a command button to your report, or change the source, so that it will prompt you for the correct date you need.

    Tell me more about the set up; I'm not the best at Reports, but I'll try and help if I can.

    J
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Reports Forms Questions
  1. contactus
    Replies:
    1
    Views:
    545
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/269404

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice