I am trying to create a report in Access 2010 using a table 'Control_Points_Master_List'.
This wikiHow teaches you how to create a database using data from a Microsoft Excel spreadsheet by importing the data directly into Access, which is Microsoft's database management software, or by exporting the Excel data into a format that works with most database software.
The 'Control_Points_Master_List' is a table with one column labeled 'Point_Designation'. For each 'Point_Designation' record there is a subdatsheet with variable amount of subdatasheet records. I want to create a report displaying all of the data found in the subdatasheet but cant seem to find a way to access the subdatasheet in the report design view.
Can anyone please help me understand the methodology to display a subdatasheet in a report?
Thanks,
dubbbdan
dubbbdandubbbdan
1 Answer
Reports don't do sub datasheets, they do sub reports.
You'll need to create another report for
BradBradPoint_Designation
and embed, as a subreport, that report in your master report. Link them appropriately on the Link Master Fields and Link Child Fields parameters.9,90933 gold badges3333 silver badges6868 bronze badges
Not the answer you're looking for? Browse other questions tagged ms-accessreport or ask your own question.
Categories: Databases | Microsoft Excel
In other languages:
Español: crear una base de datos a partir de una hoja de cálculo de Excel, Deutsch: Eine Datenbank aus einem Excel Arbeitsblatt erstellen, Português: Criar um Banco de Dados a Partir de uma Planilha do Excel, Italiano: Creare un Database da un Foglio di Calcolo di Excel, Français: créer une base de données à partir d'une feuille de calcul d'Excel, Русский: создать базу данных из электронной таблицы Excel, 中文: 创建一个Excel电子表格数据库, Bahasa Indonesia: Membuat Basis Data Dari Lembar Kerja Excel, Nederlands: Een database maken van een Excel spreadsheet, ไทย: สร้างฐานข้อมูลจาก spreadsheet ของ Excel, العربية: إنشاء قاعدة بيانات من جدول بيانات إكسل, Tiếng Việt: Tạo cơ sở dữ liệu từ bảng tính Excel, हिन्दी: एक्सेल स्प्रेडशीट (Excel Spreadsheet) से डेटाबेस तैयार करें (Create a Database from an Excel Spreadsheet), 日本語: Excelのシートからデータベースを作成する
- Edit
- Send fan mail to authors