Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Posts
    86

    Unanswered: adding variable data to maketable name

    Hi

    I have a make table query which has a date field within, the criteria is Between [Enter Start Date] and [Enter End Date]

    what i want is the results of this criteria to be added to the table name

    i.e Start Date 1/11/04 End Date 30/11/04

    run query - Make Table - Save Table with name "MyNewTable 1/11/04-30/11/04"

    is this possible?

    thanks

    Scott

  2. #2
    Join Date
    Oct 2004
    Posts
    86
    or even get access to prompt for a table name each time its run

  3. #3
    Join Date
    Oct 2004
    Posts
    86
    what i would like is either:

    for the make table query to prompt the user for a new table name
    i.e
    run qry - Prompt for Date to and from - prompt for table name - make table
    or
    for the table to be made but using the returned data from the date criteria prompt as the new table name
    i.e run qry - prompt for date to and from - make table using date to and from as table name

    thank you

    scott

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Not to appear rude, but why do you want to do this?
    oh yeah... documentation... I have heard of that.

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

Posting Permissions

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