Re: How do I translate a number to the code in a table it refers t

From: LadyAmethyst (LadyAmethyst_at_discussions.microsoft.com)
Date: 12/08/04 

Date: Wed, 8 Dec 2004 08:37:02 -0800

Thanks Allen. Just what I needed.

LadyAmethyst

"Allen Browne" wrote:

> Base the report on a query that reads the fields from both tables.
> 1. Create a query that has both tblTapes and tblRatingCodes.
>
> 2. In the upper pane of query design, you see a line joining the 2 tables.
> Double-click that line. Access offers a dialog with 3 options. Choose the
> one that says:
> All records from tblTapes, and any from ...
> (If you do not do this, any tape that has no rating will not be included.)
>
> 3. Drag the fields you need from both tables into the grid.
>
> 4. Save the query.
>
> 5. Use this query as the RecordSource for your report.
>
> It is also possible to use a DLookup() expresion in the Control Source of a
> text box on the report, e.g.:
> =DLookup("RatingsCode", "tblRatingCodes", "RatingsID = " & [Rating])
> However that will be much less efficient than the query.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "LadyAmethyst" <LadyAmethyst@discussions.microsoft.com> wrote in message
> news:B2866009-7F8A-4981-818C-14950ED74E5E@microsoft.com...
> > Hi,
> >
> > I'm using Access 97 and I want to create an Access report on a
> > table that has the following table & fields:
> >
> > tblTapes
> > ProgramID
> > ProgramName
> > YearReleased
> > Rating (this is actually the RatingsID number from the following
> > table selected on a form from a combobox.)
> >
> > tblRatingCodes
> > RatingsID
> > RatingsCode
> > RatingsExplaination
> >
> > When I use the data to print to an existing form, I use a DLookup
> > in Visual Basic. I just can't figure out how to use it on a Access
> > Report.
> >
> > Any help would be appreciated.
> >
> > Thanks,
> > LadyAmethyst
>
>
>

Relevant Pages