User Profile

Collapse

Profile Sidebar

Collapse
JJ48
JJ48
Last Activity: Oct 9 '06, 04:09 PM
Joined: Oct 4 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • JJ48
    replied to What is the most efficient way to do this?
    in Access
    Thank you PEB.
    I will work on creating the tables to have this data and then write a query to pull the right data from it.
    See more | Go to post

      Leave a comment:

    • JJ48
      replied to Location, Location, Location
      in Access
      Try (<> 10 And <> 11821) in the criteria of the query.
      See more | Go to post

        Leave a comment:

      • JJ48
        started a topic What is the most efficient way to do this?
        in Access

        What is the most efficient way to do this?

        Hi all,
        I was hoping I could get some direction for you folks on how to tackle this problem.
        Background:
        A person applying for health coverage gets assigned certain number of points which range from 1 - around 200. Based on the points and their age group, we decide what level of coverage (5 levels) they get. Each level has a maximum point allowed. The number of points per plan and level is very random. The only sequence is that...
        See more | Go to post
        No activity results to display
        Show More
        Working...