Results 1 to 4 of 4
  1. #1
    RoyLittle0 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2012
    Posts
    25

    Customers search based on area or partial post code

    Hi, I am using a modified Microsoft template (Desktop Call Tracker) i have a "Customers" Table, which contains:



    ID Auto Number
    Company
    Last Name
    First Name
    Job Title
    Address
    City
    Area
    Post Code
    Country

    How can i do a search for customers in a certain "area" of with a similar "Post Code"

    For example i want to search for all customers in the "Area" York or Birmingham
    Or
    I would like to search for all customers with a "Post Code" beginning with DE (Full post code would be DE45 6GG)

    And from this can i produce a report

    Thanks for any help

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    see this
    http://www.techonthenet.com/sql/select.php


    Get a query to give you what you want.
    Then use that query as the record source for your report.
    Good luck

  3. #3
    RoyLittle0 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2012
    Posts
    25
    Hi, Thanks for the reply.

    its the query that i am after, i am looking for something like this example

    Like "*" & [Forms]![frmSearch]![txtclaimno] & "*"

    but not sure how it works so i cant really modify it to suite what i need, once i have the query i can produce a report, that part is easy but can i do something other than a report?
    Last edited by RoyLittle0; 05-27-2013 at 02:56 AM.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Start by reviewing the Select query as per the link I gave.
    You're really dealing with a Constraint or Where clause in the Select query.
    If you start with a Select, you can identify the field you want to display.
    Then, when you add a constraint (the Where clause) you will limit your selection to certain rows, based on
    the txtclaimno value.

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

Similar Threads

  1. Creating a report based on partial field search
    By pirseinkim in forum Reports
    Replies: 1
    Last Post: 03-22-2013, 11:08 AM
  2. Texas City,State,Zip and Area Code
    By burrina in forum Sample Databases
    Replies: 0
    Last Post: 11-12-2012, 10:35 PM
  3. Return results based on a partial search
    By TimMoffy in forum Queries
    Replies: 2
    Last Post: 07-27-2012, 11:09 AM
  4. Search for partial field
    By j_a_monk in forum Queries
    Replies: 3
    Last Post: 06-08-2011, 08:40 AM
  5. Partial Matching based Queries
    By Yatesb in forum Queries
    Replies: 0
    Last Post: 02-23-2009, 01:06 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