query too complex error

[mazz]

Hi
I have created a function that has 43 parameters. When I call this function from a query the error I get is "query is too complex". This function will work if I have 28 parameters which seems to indicate a parameter number limit. Is there a way I can either call all 46 parameters or use another way.
A little background:
I have 43 columns [1] to [43] representing numbers 1 to 43 that have values of either "", A, or T.
I want to calculate whether any of these numbers (columns) have consecutive values of T. If they consecutives then I want to increase the count by 1. I have used 43 parameters to compare each number within the function.

I have also tried 2 parameters to identify the row and once inside the function have used DLookUp which gives me an error of "can't open a form whose underlying query contains a user-defined function that attempts to set or get the forms' recordsetClone property".

I hope my explanation doesn't sound too confusing. My skill level is between new to intermediate.

thanks in advance

 

[Alansidman]

This sounds like your db may not be normalized. Sounds to much like a spreadsheet if you have that many fields.

Suggest you read this before continuing.

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

 

[mazz]

Hi Alan
yes it is more a flat file than a relational DB but that is the way it was given to me and they want it kept that way but maybe I could find quick ways to normalize the data for calculations. You have me thinking