B
BruceAIS
Fellow Access Freaks
I have created a subreport that, when opened independently, works fine. When dropped on the main report and linked with a valid parent-child relationship, however, an error message is displayed during the formatting process
"The expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too may complicated elements. Try simplying the expression by assigning parts of the expression to variables.
As ususal, "Help" was of no help. There is no special code in the subreport at all, and none relating to the subform on the main report. The subreport is based upon its own "summation" query with sub-query
Primary query
SELECT [Stats - Order Status1].cam_id, [Stats - Order Status1].PresentedOrder, [Stats - Order Status1].status_code, [Stats - Order Status1].CodeMeaning, Count([Stats - Order Status1].cam_id) AS StatusCoun
FROM [Stats - Order Status1
GROUP BY [Stats - Order Status1].cam_id, [Stats - Order Status1].PresentedOrder, [Stats - Order Status1].status_code, [Stats - Order Status1].CodeMeaning
Sub-query("Stats - Order Status1")
SELECT CLng(Left([product_order_number],InStr([product_order_number],"-")-1)) AS cam_id, [Status Codes].PresentedOrder, BillingData.status_code, [Status Codes].CodeMeanin
FROM BillingData LEFT JOIN [Status Codes] ON BillingData.status_code = [Status Codes].StatusCod
WHERE (((BillingData.product_order_number) Is Not Null) AND ((BillingData.order_date)<[Forms]![AIS Billing]![HiddenDate])
ORDER BY CLng(Left([product_order_number],InStr([product_order_number],"-")-1)), [Status Codes].PresentedOrder
There are 8 other subreports on the main report, all of which are working fine and all of which use the same Parent/Child relationship ([cam_id] in subreport = [cam_id] in parent). I've double- (triple- and quad-) checked the parent-child relationship. I don't think it's a resources problem because I can delete all of the other sub-reports, leaving only the "problem" subreport, and it still fails. Again, the subreport, on its own, displays and prints great
All of the queries for the other subreports are based upon the same "source" table (BillingData) that this one is. They, of course, use different queries to extract different summary stats and detail records
Any ideas on how I can get this subreport to work correctly
Thanks
Bruc
I have created a subreport that, when opened independently, works fine. When dropped on the main report and linked with a valid parent-child relationship, however, an error message is displayed during the formatting process
"The expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too may complicated elements. Try simplying the expression by assigning parts of the expression to variables.
As ususal, "Help" was of no help. There is no special code in the subreport at all, and none relating to the subform on the main report. The subreport is based upon its own "summation" query with sub-query
Primary query
SELECT [Stats - Order Status1].cam_id, [Stats - Order Status1].PresentedOrder, [Stats - Order Status1].status_code, [Stats - Order Status1].CodeMeaning, Count([Stats - Order Status1].cam_id) AS StatusCoun
FROM [Stats - Order Status1
GROUP BY [Stats - Order Status1].cam_id, [Stats - Order Status1].PresentedOrder, [Stats - Order Status1].status_code, [Stats - Order Status1].CodeMeaning
Sub-query("Stats - Order Status1")
SELECT CLng(Left([product_order_number],InStr([product_order_number],"-")-1)) AS cam_id, [Status Codes].PresentedOrder, BillingData.status_code, [Status Codes].CodeMeanin
FROM BillingData LEFT JOIN [Status Codes] ON BillingData.status_code = [Status Codes].StatusCod
WHERE (((BillingData.product_order_number) Is Not Null) AND ((BillingData.order_date)<[Forms]![AIS Billing]![HiddenDate])
ORDER BY CLng(Left([product_order_number],InStr([product_order_number],"-")-1)), [Status Codes].PresentedOrder
There are 8 other subreports on the main report, all of which are working fine and all of which use the same Parent/Child relationship ([cam_id] in subreport = [cam_id] in parent). I've double- (triple- and quad-) checked the parent-child relationship. I don't think it's a resources problem because I can delete all of the other sub-reports, leaving only the "problem" subreport, and it still fails. Again, the subreport, on its own, displays and prints great
All of the queries for the other subreports are based upon the same "source" table (BillingData) that this one is. They, of course, use different queries to extract different summary stats and detail records
Any ideas on how I can get this subreport to work correctly
Thanks
Bruc