Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    devide record based postal code (2000)

    Have in c:cap.mdb
    In cap mdb have a table named my_cap
    2 filed: CAP end PR
    CAP numeric 5 digit
    PR text 2 digit

    I want to devide in various sheet all record based PR.
    Example:
    CAP PR
    00010 NA
    00101 RM
    45891 VE
    45788 NA
    ....

    Create if not exists new sheet NA add in column A CAP in column B PR
    in this case

    A B
    00010 NA
    45788 NA

    How to?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: devide record based postal code (2000)

    Sal

    You can do this my simply creating a Make Table Query

    SELECT my_cap.CAP, my_cap.PR

    INTO tblPR_CAP
    FROM my_cap

    WHERE my_cap.PR = "NA";

    This selects the criteria of NA from the my_cap table and then inserts it into a new table called tblPR_CAP. You can repeat this for each my_cap.PR criteria.

    I hope I have understood your request.
    Jerry

Posting Permissions

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