+8I have created the following Number Formula query in Table A:
My goal is to calculate the total records in 5 non-related Tables. The [Table Alais] field represents the Table Alais for the 5 different tables -- and the [AlaisTableFieldID] is my query field. This formula is not working.....any advice is appreciated.
Size(GetRecords("{"&[AlaisTableFieldID]&".EX.'"&[Record ID#]&"'}","&[Table Alais]&"))
Any chance your use of "Alais" instead of "Alias" is breaking your formula? Did you define the variables differently further up in the field?
+24Can you explain again what you are trying to do here? Are you saying you just want the record count in a table?
Size(GetRecords("{3.GT.0}", [Table Alais]))
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
