Forum Discussion

malcolm_p_galvin_jr's avatar
malcolm_p_galvin_jr
Copper Contributor
Oct 17, 2022
Solved

Query error message: "Too Complex"

Here is the query that works without causing the "Too Complex" error message: --COMMENT:  listing the columns of the Component table SELECT Component.ComponentID, Component.GeneralLedgerAcct, Compo...
access
  • arnel_gp's avatar
    arnel_gp
    Oct 18, 2022

    malcolm_p_galvin_jr 

     

    you can use a User-Defined-Function in your query (ms access) so you won't get the "Too Complex".

    error. see Module1 for the function.

     

    Open Query1 in design view and see how this function is being called.

arnel_gp's avatar
arnel_gp
Iron Contributor
Oct 18, 2022

malcolm_p_galvin_jr 

 

you can use a User-Defined-Function in your query (ms access) so you won't get the "Too Complex".

error. see Module1 for the function.

 

Open Query1 in design view and see how this function is being called.

Resources