I am receiving an error
"The Microsoft Jet database engine does not recognize 'tblPeriods.Effdate' as a valid field name or expression."
This error occures when I add a query to my current query - this queryt does not have a field (or parameter) called EffDate but is genrated by a series of queries and one of ,the earlier ones does include EffDate - However all the sudsequent queries work without errors until the current one.
Effdate come from a table tblPeriods and is used in subqryPremiumAnn which works (does not include EffDate as an output field)
I then use subqryPremiumAnn in subqryPremiumPeriodic which works
I then use subqryPremiumPeriodic in qryPremiumPeriodic which works
I then use qryPremiumPeriodic in subqryFatProtDoc which works
I then use subqryFatProtDoc in qryPremiumPerTonne which leads to the error.
there are no parameters used anywhere
Appreciate any help
Mark H
"The Microsoft Jet database engine does not recognize 'tblPeriods.Effdate' as a valid field name or expression."
This error occures when I add a query to my current query - this queryt does not have a field (or parameter) called EffDate but is genrated by a series of queries and one of ,the earlier ones does include EffDate - However all the sudsequent queries work without errors until the current one.
Effdate come from a table tblPeriods and is used in subqryPremiumAnn which works (does not include EffDate as an output field)
I then use subqryPremiumAnn in subqryPremiumPeriodic which works
I then use subqryPremiumPeriodic in qryPremiumPeriodic which works
I then use qryPremiumPeriodic in subqryFatProtDoc which works
I then use subqryFatProtDoc in qryPremiumPerTonne which leads to the error.
there are no parameters used anywhere
Appreciate any help
Mark H