Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    May 2003
    Location
    London, Gtr London, England
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automating a query to run 27 times (97)

    1. I have a union query that prompts the user for two inputs.
    A) A name stored in a lookup table(27 entries)
    [img]/forums/images/smilies/cool.gif[/img] A year - right now the year is 2001. That will change to 2002 in 2002.

    2. As it now stands, I have to run the query 27 times. Each time I input the Same Year but a Different Name.

    Question: Can this be automated to :
    A) read thru the table and get The Name
    [img]/forums/images/smilies/cool.gif[/img] get The Year automatically inputted

    Thanks

    Soc

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automating a query to run 27 times (97)

    Soc,
    take a look at <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=69879&page=2&vie w=expanded&sb=5&o=0&fpart=>this thread</A>
    Francois

Posting Permissions

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