Results 1 to 4 of 4

syntax for combining records in one report

  1. #1
    mainerain is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    36

    syntax for combining records in one report

    Each of these work to find corresponding records and include them in a report. I would like to somehow put the results of both in RptHistoryLoop.




    DoCmd.OpenReport "RptHistoryLoop", acViewReport, , "[FldHistoryOrigDeviceSn] = Forms![FrmFisherV150]![FldV150Sn]"

    DoCmd.OpenReport "RptHistoryLoop", acViewReport, , "[FldHistoryReplDeviceSn] = Forms![FrmFisherV150]![FldV150Sn]"


    Thank you

  2. #2
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    1,310
    Have you tried
    Code:
    DoCmd.OpenReport "RptHistoryLoop", acViewReport, , "[FldHistoryOrigDeviceSn] = Forms![FrmFisherV150]![FldV150Sn] OR [FldHistoryReplDeviceSn] = Forms![FrmFisherV150]![FldV150Sn]"
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    mainerain is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    36
    I enjoy success, thanks so much!

  4. #4
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    1,310
    You are welcome!
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Please reply to this thread with any new information or opinions.

Similar Threads

  1. summing and combining records
    By brow1726 in forum Queries
    Replies: 1
    Last Post: 08-21-2014, 11:38 PM
  2. Combining duplicate records
    By Subs in forum Queries
    Replies: 4
    Last Post: 11-13-2013, 08:53 AM
  3. Replies: 21
    Last Post: 04-03-2013, 12:51 PM
  4. combining records to show as one in a report.
    By mejia.j88 in forum Reports
    Replies: 1
    Last Post: 04-10-2012, 04:18 PM
  5. Combining Records
    By admessing in forum Queries
    Replies: 2
    Last Post: 12-15-2011, 05:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums