reference multipal table records

Discussion in 'Microsoft Access Reports' started by Guest, Apr 5, 2005.

  1. Guest

    Guest Guest

    i am trying to hack a SQL statement and i cant figure it out. will some one
    please show me what im doing wrong. i want to reference multiple tables in a
    report

    SELECT DISTINCTROW [AssetsHardware].*, [AssetsSoftware].*,
    [AssetsPrinters].*, [LastName] & ", " & [FirstName] AS [Employee Name] FROM
    [Employees] RIGHT JOIN [AssetsHardware], [AssetsSoftware], [AssetsPrinters]
    ON [Employees].[EmployeeID] = [AssetsHardware].[EmployeeID],
    [AssetsSoftware]. [EmployeeID], [AssetsPrinters].[EmployeeID];
     
    Guest, Apr 5, 2005
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Jason Frazer

    Help! multipal record report

    Jason Frazer, Nov 17, 2003, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    209
    Duane Hookom
    Nov 18, 2003
  2. Guest

    Reporting records that have no table records.

    Guest, Oct 12, 2004, in forum: Microsoft Access Reports
    Replies:
    5
    Views:
    315
    Guest
    Oct 12, 2004
  3. Guest
    Replies:
    1
    Views:
    188
    Allen Browne
    Jan 31, 2005
  4. Guest

    Printing multipal reports

    Guest, Nov 17, 2005, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    221
    Guest
    Nov 17, 2005
  5. Guest
    Replies:
    19
    Views:
    337
  6. Atif

    Multipal Filters in Single Report

    Atif, May 14, 2008, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    167
    Duane Hookom
    May 14, 2008
  7. Jacqueline

    page break a multipal page report by individual

    Jacqueline, Jun 9, 2008, in forum: Microsoft Access Reports
    Replies:
    9
    Views:
    356
    Larry Daugherty
    Jun 11, 2008
  8. Jacqueline

    Multipal parameters input

    Jacqueline, Dec 31, 2008, in forum: Microsoft Access Reports
    Replies:
    2
    Views:
    201
    Armen Stein
    Jan 1, 2009
Loading...