In Access, how can I get a field in a report to display a different value based on a reference table?
For example, I have a reference table created with two columns. One column for code, and one column for description. My main table has entries all using codes. I would like my Report to display the description instead of the code. Due to the amount of of fields in the main table, I was hoping if there's a way to modify "Record Source" within the report instead of having to create a new query.
Well, the classic approach is to use a query, either a named (stored) query, or an on-the-fly query as recordsource. Easy to debug, easy to view the recordset.
But if you must, you might use a dlookup (of description in the reference table) as the source of the description field of the report. But my bet is that would be terribly inefficient.
Query is best...
 |
 Vintage ENTRY TABLE Hand Painted Turquoise Gold Art Deco KEY TABLE Sofa Table $485.00 Time Remaining: 13h 1m Buy It Now for only: $485.00 |
 English Oak Entry Table Hall Table or Sofa Table $325.00 Time Remaining: 17h 54m Buy It Now for only: $325.00 |
 Carved Mahogany Inlaid Parlor Table Entry Table $449.00 Time Remaining: 18h 51m Buy It Now for only: $449.00 |
 Cherry Parlor Table Entry Table $399.00 Time Remaining: 18h 51m Buy It Now for only: $399.00 |
 Intricate Carved Dining Table Office Desk Entry Occasional Table Antique French $4,250.00 Time Remaining: 1d 9h 29m |
 Art Deco Solid Maple Biedermeir Style Cocktail or Entry Table Needs Refinishing $488.88 Time Remaining: 1d 11h 50m Buy It Now for only: $699.00 |
 Beautiful Asian Style Altar Entry Table $4,800.00 Time Remaining: 1d 12h 27m Buy It Now for only: $4,800.00 |
 Victorian Walnut Entry Table or Server $495.00 Time Remaining: 1d 13h 5m Buy It Now for only: $495.00 |
 antique cabinet TV stand entry table $290.00 Time Remaining: 1d 14h 5m |
 Sofa Entry Table Made From 1930s Repurposed Foundry Mould Parts Deco Mod Charm $890.00 Time Remaining: 1d 15h 20m Buy It Now for only: $890.00 |
 Rustic Entry Table Sideboard from Vintage Reclaimed Wood $295.00 Time Remaining: 1d 20h 17m Buy It Now for only: $295.00 |
 Mahogany with Satin Wood Banding Dining Entry Way Foyer Table $1,095.00 Time Remaining: 2d 9h 12m Buy It Now for only: $1,095.00 |
 Art Deco Entry Table with Leather Top $1,825.00 Time Remaining: 2d 13h 37m Buy It Now for only: $1,825.00 |
 Danish Modern TEAK Entry Hall Chest Bench Table Nakashima Mid Century Eames $306.00 (24 Bids) Time Remaining: 2d 18h 53m |
 Danish Modern TEAK Drawer Chests Entry Nightstand Tables Mid Century Eames Era $305.00 (13 Bids) Time Remaining: 2d 18h 58m |
 Berkey and Gay Mahogany Entry Table with Painted Detailing $495.00 Time Remaining: 3d 13h 26m Buy It Now for only: $495.00 |
 Walnut Mahogany Book Match Entry Table or Sofa Table $499.00 Time Remaining: 3d 13h 50m Buy It Now for only: $499.00 |
 BEAUTIFUL ORNATE SOFA ENTRY TABLE WITH INLAID AND HAND CARVED DETAIL $517.50 Time Remaining: 3d 14h 14m Buy It Now for only: $517.50 |
 Marble Top Neo Classical Style Hall or Entry Console Table with Mirror $425.00 Time Remaining: 4d 12h 23m Buy It Now for only: $425.00 |
 mission style arts crafts raven tile wrought iron entry table $5,800.00 Time Remaining: 4d 13h 18m Buy It Now for only: $5,800.00 |
 Victorian Oak Entry Table Server w Carved Paw Feet Cathedral Carved Columns $895.00 Time Remaining: 4d 15h 19m Buy It Now for only: $895.00 |
 VTG Eames Era DANISH MODERN TEAK END ENTRY SIDE TABLE $199.00 Time Remaining: 4d 16h 29m Buy It Now for only: $199.00 |
 Oak Entry Hall Table Ornately Carved Lions Paw Feet Center Table $500.00 Time Remaining: 5d 8h 15m Buy It Now for only: $1,995.00 |
 Antique Sewing Machine Base Table or Stand Bedroom Entry Room Living Whites $125.00 Time Remaining: 5d 9h 52m Buy It Now for only: $125.00 |
 Walnut Carved Crotch Veneer Inlaid Demilune Table Entry Table by Imperial $299.00 Time Remaining: 5d 11h 42m Buy It Now for only: $299.00 |
 ITALIAN RENAISSANCE STYL BAROQUE CARVED WOOD ENTRY DINING TABLE BASE LION FEET $1,450.00 Time Remaining: 5d 19h 16m Buy It Now for only: $1,450.00 |
 BIEDERMEIER DECO STYLE STARBURST INLAY TOP ENTRY GAME ROUND END TABLE REGENCY $945.00 Time Remaining: 5d 19h 31m Buy It Now for only: $945.00 |
 ITALIAN WALNUT CARVED RENAISSANCE ANTIQUE OCTAGONAL ENTRY OCCASSIONAL TABLE $1,150.00 Time Remaining: 5d 21h 52m Buy It Now for only: $1,150.00 |
 ITALIAN HOLLYWOOD REGENCY MARBLE ENTRY END TABLE PAIR $348.00 Time Remaining: 6d 11m Buy It Now for only: $348.00 |
 DREXEL HERITAGE BIEDERMEIER STARBURST DECO STYL ENTRY GAME END TABLE SM DINING $875.00 Time Remaining: 6d 34m Buy It Now for only: $875.00 |
 SALE FRENCH CARVED CONSOLE ENTRY SOFA TABLE SERVER $1,150.00 Time Remaining: 6d 1h 48m Buy It Now for only: $1,150.00 |
 Elm Entry Table Sofa Table $250.00 Time Remaining: 6d 8h 32m Buy It Now for only: $250.00 |
 Beautiful English Oak Arts Crafts Side Entry Table $400.00 Time Remaining: 6d 13h 58m Buy It Now for only: $400.00 |
 Walnut Entry Table Hall Table Side Table $149.00 Time Remaining: 6d 18h 22m Buy It Now for only: $149.00 |
 Vintage French Provincial CORNER TABLE Entry Table Handpainted Turquoise $559.00 Time Remaining: 6d 22h 47m Buy It Now for only: $559.00 |
 Antique Marble ivory ceramic gold grape leaf entry hallway table living room VTG $350.00 Time Remaining: 7d 7h 17m Buy It Now for only: $350.00 |
 Quartersawn Oak Oval Entry Table Parlor Table $399.00 Time Remaining: 7d 18h 50m Buy It Now for only: $399.00 |
 COLONIAL Furniture Mahogany 1 Drawer Drop Side Entry Hall Occasional Table $799.00 Time Remaining: 8d 4h 42m Buy It Now for only: $799.00 |
 Mahogany Flower Carved Marble Top Parlor Table Entry Table TKC $599.00 Time Remaining: 8d 16h 53m Buy It Now for only: $599.00 |
 CIVIL WAR TABLE FOYER ENTRY SOLID CHERRY BALL CLAW AUTHENTIC RARE $829.99 Time Remaining: 9d 7h 12m Buy It Now for only: $829.99 |
 Oak Carved Parlor Table Entry Table Center Table $349.00 Time Remaining: 9d 10h 9m Buy It Now for only: $349.00 |
 Walnut Carved Sofa Table Entry Table $249.00 Time Remaining: 9d 10h 30m Buy It Now for only: $249.00 |
 Elegant Antiques Cabinet Entry Display Table d133s $750.00 Time Remaining: 9d 11h 56m Buy It Now for only: $750.00 |
 Mahogany Parlor Table Entry Table Center Table $399.00 Time Remaining: 10d 16h 57m Buy It Now for only: $399.00 |
 Mahogany Hepplewhite Inlaid Entry Table by Hammary $499.00 Time Remaining: 10d 19h 7m Buy It Now for only: $499.00 |
 Quartersawn Oak Black Iron Entry Table $499.00 Time Remaining: 10d 19h 7m Buy It Now for only: $499.00 |
 Mahogany Demilune Turned Leg Table Entry Table End Table $199.00 Time Remaining: 10d 19h 10m Buy It Now for only: $199.00 |
 spanish colonial tile wrought iron entry table no2 $7,500.00 Time Remaining: 11d 10h 23m Buy It Now for only: $7,500.00 |
 Antique Hand Lacquered Square Entry Table Console Ca1770 1800 $2,200.00 Time Remaining: 11d 11h 35m Buy It Now for only: $2,200.00 |
 ANTIQUE ROUND DARK OAK DINING ENTRY TABLE W 9 LEAF $499.99 Time Remaining: 12d 17h 10m Buy It Now for only: $499.99 |
 Oriental Metallic Painted Entry Table with Dark Stained Legs $250.00 Time Remaining: 13d 9h 36m Buy It Now for only: $250.00 |
 GORGEOUS Antique LOUIS XIV Style Marble Top Entry Table Mirror ORNATE $1,500.00 Time Remaining: 14d 17h 45m Buy It Now for only: $1,500.00 |
 Vintage Chic Shabby Pedestal TABLE Hand Painted WHITE French Country Entry Table $659.00 Time Remaining: 14d 20h 57m Buy It Now for only: $659.00 |
 Solid Walnut Work Table Entry Table with Drawer $399.00 Time Remaining: 16d 18h 22m Buy It Now for only: $399.00 |
Tags: css, entry table, entry table and mirror, entry table and mirror set, entry table ideas, entry table plans, entry table with storage, html, table, tips, webdesign