We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

MS Access Report SQL Query result in Text Box

stmoline
stmoline asked
on
Medium Priority
564 Views
Last Modified: 2013-11-28
Hi,

I'm new to MS access Reports so please bear with me.

I have a text box where I'm trying to set the data source using a SQL Query:

SELECT SUM(AMT)
FROM dbo_INTable
WHERE CODE='S';

Open in new window


and when I view the report, all I get is "#NAME?" in the text box.  I've also tried creating the SQL statement as an Access query (the query works) and using that as the control source but I still get the same result.  Any idea what I'm doing wrong?
Comment
Watch Question

Engineering Manager
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Okay, that pointed me in the right direction.  I think I got it now.  Thank you for your assistance.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.