Results 1 to 2 of 2
  1. #1
    gromit95 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2008
    Posts
    12

    Smile need help with queries

    i have 5 yearly price books with (pn description price)


    i made a query for each year with a search by part number
    the results dumps into a table. i then use a report to display the results.
    i have one line per year. the problem i have is i need to enter the part number 5 times, once for each query. is there a way to automate this.
    i'm a novice at this so keep is as simple as possible

    thanks for your help
    fred

  2. #2
    gromit95 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2008
    Posts
    12

    oops

    i'm using access 2003 with xp
    fred

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Combining Two Queries
    By csolomon in forum Queries
    Replies: 1
    Last Post: 09-03-2009, 01:33 PM
  2. Crosstab Queries
    By albst130 in forum Queries
    Replies: 0
    Last Post: 03-07-2007, 09:32 AM
  3. Queries the max from two rows
    By mohsin74 in forum Queries
    Replies: 0
    Last Post: 12-15-2006, 12:52 AM
  4. VBA and stacked queries
    By Pudy in forum Queries
    Replies: 0
    Last Post: 11-28-2006, 03:58 PM
  5. Time queries
    By ddog171 in forum Queries
    Replies: 2
    Last Post: 06-04-2006, 06:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums