Hello,
I am new to Access and was given a 4 year old application for my internship. I have a Access 2013 front end that connects to a SQL 2008 database.
I have created two queries and then joined them into a single query (using Access design view). The query runs and returns the data I need in a spreadsheet, but when I go to open the report I get the error message:
"This expression is typed incorrectly, or it is too complex to be evaluated."
Here is my query:
SELECT
DepositMonthlyQuery.mydate,
DepositMonthlyQuery.DepositDate,
DepositMonthlyQuery.RentSum,
DepositMonthlyQuery.UtilSum,
DepositMonthlyQuery.LDSum,
DepositMonthlyQuery.IntSum,
DepositMonthlyQuery.SecuritySum,
DepositMonthlyQuery.OtherSum,
DepositMonthlyQuery.TotalSum,
TransactionQueryForDeposits.mydate,
TransactionQueryForDeposits.TransactionDate,
TransactionQueryForDeposits.SumOfRentTransaction,
TransactionQueryForDeposits.SumOfUtilityTransaction,
TransactionQueryForDeposits.SumOfLongDistanceTransaction,
TransactionQueryForDeposits.SumOfInternetTransaction,
TransactionQueryForDeposits.SumOfDepositTransaction,
TransactionQueryForDeposits.SumOfOtherTransaction
FROM
DepositMonthlyQuery INNER JOIN TransactionQueryForDeposits
ON DepositMonthlyQuery.mydate = TransactionQueryForDeposits.mydate
GROUP BY
DepositMonthlyQuery.mydate,
DepositMonthlyQuery.DepositDate,
DepositMonthlyQuery.RentSum,
DepositMonthlyQuery.UtilSum,
DepositMonthlyQuery.LDSum,
DepositMonthlyQuery.IntSum,
DepositMonthlyQuery.SecuritySum,
DepositMonthlyQuery.OtherSum,
DepositMonthlyQuery.TotalSum,
TransactionQueryForDeposits.mydate,
TransactionQueryForDeposits.TransactionDate,
TransactionQueryForDeposits.SumOfRentTransaction,
TransactionQueryForDeposits.SumOfUtilityTransaction,
TransactionQueryForDeposits.SumOfLongDistanceTransaction,
TransactionQueryForDeposits.SumOfInternetTransaction,
TransactionQueryForDeposits.SumOfDepositTransaction,
TransactionQueryForDeposits.SumOfOtherTransaction;
In the Record Source for the Report if I do not select a source the report will load fine (no data of course), however if I use the previous query I get the error message listed above.
I am new to both Access 2013 and have only taken an intro course to database so any help would be greatly appreciated. If I posted in the wrong section I am sorry, I felt this was more of a query issue then a reporting issue.
Thanks in advance!
Eric
I am new to Access and was given a 4 year old application for my internship. I have a Access 2013 front end that connects to a SQL 2008 database.
I have created two queries and then joined them into a single query (using Access design view). The query runs and returns the data I need in a spreadsheet, but when I go to open the report I get the error message:
"This expression is typed incorrectly, or it is too complex to be evaluated."
Here is my query:
SELECT
DepositMonthlyQuery.mydate,
DepositMonthlyQuery.DepositDate,
DepositMonthlyQuery.RentSum,
DepositMonthlyQuery.UtilSum,
DepositMonthlyQuery.LDSum,
DepositMonthlyQuery.IntSum,
DepositMonthlyQuery.SecuritySum,
DepositMonthlyQuery.OtherSum,
DepositMonthlyQuery.TotalSum,
TransactionQueryForDeposits.mydate,
TransactionQueryForDeposits.TransactionDate,
TransactionQueryForDeposits.SumOfRentTransaction,
TransactionQueryForDeposits.SumOfUtilityTransaction,
TransactionQueryForDeposits.SumOfLongDistanceTransaction,
TransactionQueryForDeposits.SumOfInternetTransaction,
TransactionQueryForDeposits.SumOfDepositTransaction,
TransactionQueryForDeposits.SumOfOtherTransaction
FROM
DepositMonthlyQuery INNER JOIN TransactionQueryForDeposits
ON DepositMonthlyQuery.mydate = TransactionQueryForDeposits.mydate
GROUP BY
DepositMonthlyQuery.mydate,
DepositMonthlyQuery.DepositDate,
DepositMonthlyQuery.RentSum,
DepositMonthlyQuery.UtilSum,
DepositMonthlyQuery.LDSum,
DepositMonthlyQuery.IntSum,
DepositMonthlyQuery.SecuritySum,
DepositMonthlyQuery.OtherSum,
DepositMonthlyQuery.TotalSum,
TransactionQueryForDeposits.mydate,
TransactionQueryForDeposits.TransactionDate,
TransactionQueryForDeposits.SumOfRentTransaction,
TransactionQueryForDeposits.SumOfUtilityTransaction,
TransactionQueryForDeposits.SumOfLongDistanceTransaction,
TransactionQueryForDeposits.SumOfInternetTransaction,
TransactionQueryForDeposits.SumOfDepositTransaction,
TransactionQueryForDeposits.SumOfOtherTransaction;
In the Record Source for the Report if I do not select a source the report will load fine (no data of course), however if I use the previous query I get the error message listed above.
I am new to both Access 2013 and have only taken an intro course to database so any help would be greatly appreciated. If I posted in the wrong section I am sorry, I felt this was more of a query issue then a reporting issue.
Thanks in advance!
Eric