Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Expression Builder - length problem

Status
Not open for further replies.

KRC

MIS
Dec 8, 2001
1
US
I've got a function which takes about 25 variables and is used to validate the net worth of a balance sheet. Works fine in access 97 SR-2 in the NT environment at work. Home Win 98 access 2000 chops off the last third of the expression in the expression builder:

e_NetWorth: e_NetWorth([cash_and_equivalents_year_1],[net_trade_receivables_year_1],[inventory_year_1],[other_current_assets_1_year_1],[other_current_assets_2_year_1],[other_current_assets_3_year_1],[net_plant_and_equip_year_1],[other_non_curr_assets_1_year_1],[other_non_curr_assets_2_year_1],[other_non_curr_assets_3_year_1],[intangible_assets_year_1],[notes_payable_year_1],[current_long_term_debt_year_1],[trade_payables_year_1],[taxes_payable_year_1],[other_curr_liabilities_1_yr_1],[other_curr_liabilities


Function e_NetWorth(CashEQ, AR, INV, OCA1, OCA2, OCA3, NPE, ONCA1, ONCA2, ONCA3, _
IntA, NP, CLTD, TradeP, TaxP, OCL1, OCL2, OCL3, OLTL1, OLTL2, OLTL3, NW, OverrideReason, decision, TypeFin) As Variant

The query itself has about 40+ fields using custom functions to check a database for data validity - works fast in NT, slow in Win 98 despite PIII w/ 128 RAM. Does anybody know if there is a limitation on the length of the expression or if there is a difference between NT and Win98 causing this to happen?

Any help, ideas, or clues would be very welcome.
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top