Re: Missing Fields from report
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Mon, 23 Mar 2009 10:26:12 -0600
TimJames wrote:
I have created a Request table with references to another table (Requesting
Employees), then created a form based upon the Request table. The fields in
the requesting Employee table are Employee, Extension, Department. The form
will self populate the Extension and Department fields after selecting the
Employee name. This information is saved and reviewable in the form, but not
in my Request table nor in any reports I generate listing the requests. Any
idea how I get the Extension and Deparments to list in my reports? (And to
save in my table would be nice also, but I am mostly concerned with the
information appearing in my reports.) I am using Office 2007.
The report's record source query need to join the two
tables. Create a new query, select both tables, make sure
there's a connecting line between the linking fields and
then drag the needed fields from both tables to the query's
field list.
Except for the linking field(s), you DO NOT want to include
fields from one table in another table.
--
Marsh
MVP [MS Access]
.
- References:
- Missing Fields from report
- From: TimJames
- Missing Fields from report
- Prev by Date: Re: table format in report
- Next by Date: Re: One report to multiple file exports.
- Previous by thread: Re: Missing Fields from report
- Next by thread: not printing empty fields on labels
- Index(es):
Relevant Pages
|
