Sherry McCain
asked on
MS Access #Type! error on report with subreports
I have a report with 7 sub reports. My main report contains calculated controls that uses totals from fields in the different sub reports. The controls calculate when in layout view, but in print preview I receive the "#Type!" error. I know it's because some sub reports don't have data but I still need it to calculate and show on my report when printed.
How do I get it to display on my report when printed?
This is my expression I use in expression builder as my control source for the text box:
=[subrptTIPS].[Report]![YT
How do I get it to display on my report when printed?
This is my expression I use in expression builder as my control source for the text box:
=[subrptTIPS].[Report]
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Dale Fye
glad I could help
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
