Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: How can I set the values?

    Hi

    In query:

    How can I set the values?

    Select [Vendor Name]
    where [Date Received] = [Please enter the date]
    From Input
    Union
    Select [Vendor Name]
    where [Date Received] = Input.[Date Received]
    From Month_Report

    Can I pass the date value from Input to the Month Report date value. Because they are same date. This way I just input once.
    Does that run correctly?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You'd be much better off using a small form with a text box to capture the criteria. You can then refer to this text box using the convention forms!yourForm!yourTextBox
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Sep 2005
    Posts
    313
    I want to use in query.

    I don't want to use forms.

  4. #4
    Join Date
    Sep 2005
    Posts
    313
    It's fine.

    I know how to do.

    Thanks a lot.

Posting Permissions

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