Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. #16
    skydivetom is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    1,038
    Just like with the owners, I MUST GROUP the records. Thus, I know that I have to use "HAVING" now.

    At this time, however, given the alias, it creates a new field (expression) vs. plugging the listbox value into the existing NCode_Group: NCode_Group([N_Code]).

    I 99% confident that once I have a correct strCriteria, the original process will work for this one too.

    Any thoughts on how to rewrite the line?
    strCriteria = "Q201_CFT_Participation_Report_Ncode_Gonzales_ RPT.NCode_Group = '" & Me!lstCFTParticipants.ItemData(varItem) & "'"


    Pls refer back to the images of the "Before" and "After". After query execution, the query (in design) must just like the "Before"... but it doesn't... urgh!


  2. #17
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Repeat the calculation:

    strCriteria = "NCode_Group([N_Code]) = '" & Me!lstCFTParticipants.ItemData(varItem) & "'"

    Does Q201_CFT_Participation_Report_Ncode_Gonzales_ RPT really have a space before RPT?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #18
    skydivetom is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    1,038
    June7.... YES!!! Now it executes w/o errors. Participation reports are being output.

    I will have to do some validation (e.g., record counts, etc.) but I totally thrilled that both processes out their respective report. Thank you so very much for your patience and continued contributions.

  4. #19
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    I MUST GROUP the records. Thus, I know that I have to use "HAVING" now.
    I don't think you have understood what I have been saying. But no matter, you have something that works. Good luck with your project

  5. #20
    skydivetom is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    1,038
    Maybe not... either way, I'm happy the current process works. I appreciate your recommendations... if I neglected to implement a proposed method, it wasn't intentional -- I probably just couldn't figure out the implementation.

    Again, thanks!
    Tom

  6. #21
    skydivetom is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    1,038
    I posted a new (but related) question pertaining this process.

    I'd welcome any additional feedback on this topic. Thank you!
    https://www.accessforums.net/showthr...542#post437542

  7. #22
    skydivetom is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    1,038
    ssanfu:

    I opened a new/related post. I'd like to slightly tweak the report's filename output to include a date.
    https://www.accessforums.net/showthr...984#post437984

    I'd welcome any thoughts you could provide at the new post.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 10-31-2014, 06:51 AM
  2. Replies: 4
    Last Post: 04-23-2014, 04:35 PM
  3. Replies: 0
    Last Post: 03-07-2012, 08:10 AM
  4. Automate report on ACCESS
    By Schoolo in forum Database Design
    Replies: 1
    Last Post: 12-18-2011, 02:11 AM
  5. Automate Printing Report
    By Kagbodo in forum Reports
    Replies: 5
    Last Post: 07-01-2011, 02:19 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
  •  
Other Forums: Microsoft Office Forums