Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / January 2006

Tip: Looking for answers? Try searching our database.

look-up fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Smitty - 04 Jan 2006 07:21 GMT
I am trying to produce a report. The database I created is organized around
my review of  articles published in scientific journals.  The report is based
on a table called "Findings".  There are about 5 fields from  the table that
I would like to use in my repoort.  They are CiteID, independentvariable,
dependentvariable, statisticalsignificance and citeid.  The fields citeID,
independentvariable and dependentariable are lookup fields The citeID field
is a field in a parent table called Citation.  The fields independent
variable and dependentvariable are lookup fields from a child table to a
table called variables.. The parent table is "Variables".
The table "Variables" has the fields variablename, variabletype, .

Whenever, I try to print a report that  is based on the table findings in
which  the field independentvariable or dependent variable is used as a
grouping variable, the text characters will print for only one of the fields,
not both.  Instead, for the lookup field that is used as a grouping variable
an interger prints.  However, when I use the citeID variable as a grouping
variable, the textname prints out.

Help! This is  my first time out the gate with this software.  I am trying
to use it  for some of my  academic duties.
Duane Hookom - 04 Jan 2006 13:21 GMT
Consider never using lookup fields
http://www.mvps.org/access/lookupfields.htm. If you want a text value to
appear in a report in place of the numeric code, add the table containing
the text value to your report's record source.

Signature

Duane Hookom
MS Access MVP
--

>I am trying to produce a report. The database I created is organized around
> my review of  articles published in scientific journals.  The report is
[quoted text clipped - 21 lines]
> Help! This is  my first time out the gate with this software.  I am trying
> to use it  for some of my  academic duties.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.