I have a continuous form with some calculated fields in the form footer.
For instance: the form lists sales opportunities and includes the amount for each opportunity record.
In the footer is a text box which displays the sum of the sales amounts.
Filter the continuous form; the sum shows only what's displayed on the filter.
The field on the continuous form is EstimatedAmount and the control source for the footer text box is
Code:
=Sum([EstimatedAmount])
The record source for the form is
Code:
SELECT tblOpportunities.OpportunityID, tblOpportunities.CreateDate, tblOpportunities.AccountID, tblOpportunities.OpportunityOwner, tblOpportunities.OpportunityName, tblOpportunities.LeadSource, tblOpportunities.EstimatedAmount, tblOpportunities.EstimatedRMR, tblOpportunities.Probability, tblOpportunities.Status, tblOpportunities.CloseDate, tblOpportunities.SalesStage, tblOpportunities.NewAccount, tblAccounts_Vendors.AccountName FROM tblOpportunities INNER JOIN tblAccounts_Vendors ON tblOpportunities.AccountID = tblAccounts_Vendors.AccountID;
This works just fine in my native access database.
Now, I used the Microsoft SQL Server Migration Assistant for Access (SSMA) to convert this app to use a SQL back-end.
Everything appears to be working normally, the continuous form displays properly and filters normally, but those fields in my footer just show "#Error"
There is absolutely no change to the form, or the record sources for anything, only difference is that the linked table is now SQL instead of Access.
Access 2016.
SQL 2014.
Windows 10.