This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Little issue here: I am extracting data from a warehouse and running it through a bunch of tools to get it shapely enough to fit into an oddly designed MS Access table. Basically the table is a sort of giant cross tab report (don't ask me why) with - among other things - claim numbers going across the top. For example: Name, Claim_1, Claim_2, Claim_3 up to Claim_15.
To get claim position by member I use a ranking formula, and in order to get the data ready for loading this table I use crosstab and summary tools. The problem is there will not always be 15 claims for any one member (sometimes the max per member is only 2), in which case the summary tools will throw an error ("The field Claim_15 is not contained in the record").