MS Access Report SQL Query result in Text Box

Posted on 2011-04-28
Last Modified: 2013-11-28

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:

FROM dbo_INTable

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?
Question by:stmoline
    LVL 10

    Accepted Solution

    There are two keys things you need to do here.  Assuming your query works correctly.

    When you create a new report you want to set the recordsource of the report to your query.

    Then place a text box on the report detail section, and set the control source of the text box to be the field from your query.

    Author Comment

    Okay, that pointed me in the right direction.  I think I got it now.  Thank you for your assistance.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now