473,324 Members | 2,196 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

MS Access 2003 – table inside a report???

MS Access 2003 – table inside a report

I have an Access report that I use in a mail merge (export to Excel and then mail-merge into a Word document). The report currently shows:
CustomerId
CustomerName
SaleRepName
ContractNumber
ContractDate

I need to include data that shows the products and their respective serial numbers owned by the customer. A customer can have multiple products. For example:
CustomerId: 123456
Customer Name: ABC Corporation
Sales Rep: Joe Smith
Contract #: 200-1234567-000
Contract Date: 07/01/2007
Model/Serial #:AB800 123456789, AB800 987654321, ZZ450 457052997

Alternatively, if I can pull the Model/Serial data into Word as a table it could be something like:
CustomerId: 123456
Customer Name: ABC Corporation
Sales Rep: Joe Smith
Contract #: 200-1234567-000
Contract Date: 07/01/2007
Model/Serial:AB800 123456789
Model/Serial: AB800 987654321
Model/Serial: ZZ450 457052997

All help is appreciated.
Thanks,
Sep 29 '08 #1
1 1795
NeoPa
32,556 Expert Mod 16PB
Are you asking how to include data from another table into your report?
Sep 29 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

20
by: John | last post by:
Hi, I've recently upgraded from Access 97 to Access 2002 & the performance basically stinks. I have tried the following items listed below but it has only had a minor impact: 1) Upgraded Jet...
5
by: Prakash | last post by:
Hi, In my Access Report ... If there is "NO" entry i.e. (no corresponding CODE) in my Data-File, then even the Master-File entry does not show up in the report. eg. Mast-File Code Op.Bal
7
by: manning_news | last post by:
I've got a report that's not sorting correctly. I build a SQL statement and assign it to the recordsource in the Open event, sorting the data the way the user chooses. The user can choose up to 3...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
17
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...
4
by: amanda27 | last post by:
Is there anyway to create a table on a report in access that the table cell is only as big as the data that is in it. For instance all the cells are taking up 1 page per the report because one cell...
2
by: Andy | last post by:
Hi guys I having a problem creating a report in Access 2003 project talking to a SQL database through and ODBC connect. After hours of trying things from Access Help, MSDN and Google I still...
2
Zwoker
by: Zwoker | last post by:
Hi all, I have what appears to be a simple requirement in an MS Access (2003) report, but I just can't get it to work without it causing problems. I have a table with data I want to report on,...
4
by: Harry | last post by:
Hi Guys I dont really know how to do this: if there are a page of others, some data are embedded inside the data array like this: <script language="JavaScript" type="text/javascript"> <!-- var...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.