Results 1 to 3 of 3

Thread: Query

  1. #1
    Join Date
    Mar 2004
    Posts
    128

    Unanswered: Query

    Hi,
    I have a table whitch consist of three fieldsate,FieldName,Water
    I built a query whitch calculate the following:
    Water quantity between two givven days,Average,sumof water...
    My quesion : how can I display the query results in a form textboxs.
    I want If I click a botton that run the query,I see the results in the text boxes and not to open the query...
    best regards...

  2. #2
    Join Date
    May 2004
    Posts
    55
    You can use "create a form by using wizard" option and then select the query from the drop down...

    Quote Originally Posted by wasimf
    Hi,
    I have a table whitch consist of three fieldsate,FieldName,Water
    I built a query whitch calculate the following:
    Water quantity between two givven days,Average,sumof water...
    My quesion : how can I display the query results in a form textboxs.
    I want If I click a botton that run the query,I see the results in the text boxes and not to open the query...
    best regards...

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Or you can change your query to a create table query, then use the created table as a RecordSource of your Form

Posting Permissions

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