Results 1 to 2 of 2
  1. #1
    Zahed is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    1

    Make table query

    I have a Master table which has employees and departments. I want to run Maketable type of query or another solution so it splits the Master table into several tables by department.

    Is there any other way, rather creating 20 make-table queries (for 20 departments) and then putting this into a Macro



    thanks

    help would be appreciated

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    Why do you want to split them up? You can use queries to group or filter by departments

    David

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

Similar Threads

  1. Replies: 2
    Last Post: 10-27-2009, 07:09 AM
  2. Make Table Query Issue
    By tmcrouse in forum Access
    Replies: 0
    Last Post: 07-23-2009, 03:20 PM
  3. Make a table query
    By Fiona in forum Access
    Replies: 4
    Last Post: 06-25-2009, 11:24 AM
  4. Add descriptions for make table queries
    By HurrMark in forum Access
    Replies: 0
    Last Post: 12-30-2008, 08:29 AM
  5. Adding new column to make-table query
    By dtn118 in forum Access
    Replies: 2
    Last Post: 08-03-2008, 06:51 AM

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