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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jason Frazer

    Help! multipal record report

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

    Printing multipal reports

    Guest, Nov 17, 2005, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    143
    Guest
    Nov 17, 2005
  3. Atif

    Multipal Filters in Single Report

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

    page break a multipal page report by individual

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

    Multipal parameters input

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

Share This Page