Results 1 to 2 of 2
  1. #1
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368

    assigning probability

    Hi everyone,



    Background:
    I am working on a project and I'm stuck. After a series of user entries and queries, I generate a table that contains, among other things, zip codes for customers. I have another table which has fields for Contractor and the zip codes they are assigned to. Multiple entries for each contractor if they have multiple zip code jurisdictions.
    I need to attach these contractors to my first table, creating 3 new fields PrimaryCont, Secondary, Tertiary. Usually I would use a crosstab query to get this done. However, some contractors are given preference over others and the total list can only have a certain percentage be assigned to a certain contractor.

    My requirements for assigning a contractor:
    1. certain contractors are given priority over other contractors
    2. only a certain % of the total may be assigned to a particular contractor.

    My issues:
    I think I can come up with a way to decide who would go first but for the life of me cant figure out how to incorporate that into a crosstab query to get the results as I want them

    Thanks a bunch everyone. Let me know if further clarification is needed.

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    If you have a way of determining (via queries) the amount assigned to each contractor, then it would help to have a table to define what percent each contractor should get as a maximum. For example:

    Code:
    Contractor	Limit
    ContractorA	12%
    ContractorB	8%
    ContractorC	4%
    ContractorD	10%
    ContractorE	25%
    ...
    Then, all you need do is build a query to compare the assigned amount to the maximum, and report to you which ones require adjustment.

    Cheers,

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

Similar Threads

  1. Assigning values to duplicate records
    By matteu1 in forum Queries
    Replies: 3
    Last Post: 02-17-2010, 10:35 PM
  2. Assigning Values/Scorecard
    By nicholali in forum Access
    Replies: 0
    Last Post: 11-17-2008, 03:20 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