Results 1 to 9 of 9
  1. #1
    JohnLouisWood is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Mar 2023
    Posts
    52

    Printing multiple values on a single line


    I am trying to create a narrative sub-report to 'talk about' consecutive win seasons.
    I had hoped to include screenshots of the sub-report and the design, and the other query that I also need info from, but I obviously do not know how.
    Part of the reason for sending this thread, is that I have a section that presently has 2 entries, but on other similar sub-reports, could be 1, or could be more.
    Thank you in advance for any assistance.
    I had tried taking a snip, saving it to WORD, adjusting the size, and copying it to this thread.Click image for larger version. 

Name:	Screenshot (30).jpg 
Views:	21 
Size:	105.9 KB 
ID:	49996Click image for larger version. 

Name:	Screenshot (31).jpg 
Views:	19 
Size:	200.8 KB 
ID:	49997Click image for larger version. 

Name:	Screenshot (32).jpg 
Views:	18 
Size:	148.2 KB 
ID:	49998
    I've included screenshots, I hope somebody can read them.
    (a) is the sub-report, (b) is the design and (c) is the 'new' query. I original text comes from Var_15cws_q4_Query, while the 'new' query is Var_15cws_q2_Query
    Well, here goes.

  2. #2
    JohnLouisWood is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Mar 2023
    Posts
    52
    Sorry, I should have included the next line in the sub-report.
    The varsity accomplished this for the seasons: Text-box 1979-80 Label thru Text-box 1982-83 Label and from Text-box 1987-88 Label thru 1990-91
    So it should show: The varsity accomplished this for the seasons: 1979-80 thru 1982-83, and from 1987-88 thru 1990-91
    But, often the 'best' would only happen 1 time, instead of 2 times like this did. Or, it could possibly happen 3 or more times.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    It is not clear to me what the issue is. What do you mean by "Printing multiple values on a single line"?
    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.

  4. #4
    JohnLouisWood is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Mar 2023
    Posts
    52
    I guess my first issue should be able for ACCESS to print the first set of 4 consecutive years from v2 query i.e. 1979-80 thru 1982-83

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    And how should Access know what constitutes a 'set of 4 consecutive years'? What criteria determines where each set begins and ends? Why does first record not seem to have data like other records?
    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.

  6. #6
    JohnLouisWood is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Mar 2023
    Posts
    52
    Well, I was able use queries v2 and v3 - not joined, and was able to include the seasons in v4, BUT first first was 1989-90 and last first was 1979-80. Why was this?
    SELECT Var_15cws_v3_Query.Total15ws, First(Var_15cws_v3_Query.Max_cws) AS F_Max_cws, Count([Var_15cws_v2_Query]![CountY]) AS Cnt_Max, First(Var_15cws_v2_Query.Fir_Seas) AS Fir_Fir, First(Var_15cws_v2_Query.lst_Seas) AS Fir_End, Last(Var_15cws_v2_Query.Fir_Seas) AS Sec_Fir, Last(Var_15cws_v2_Query.lst_Seas) AS Sec_End
    FROM Var_15cws_v3_Query, Var_15cws_v2_Query
    WHERE ((([Var_15cws_v2_Query]![CountY])=[Var_15cws_v3_Query]![Max_cws]))
    GROUP BY Var_15cws_v3_Query.Total15ws;
    I got a ding that you answered something. I will check in a moment.

  7. #7
    JohnLouisWood is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Mar 2023
    Posts
    52
    The CountY is what counts the number of consecutive years of 15+ wins. The CountN counts the number of consecutive NON-15+ seasons.
    The first line is different because my module first looks at NON seasons, before then looking at 15+ wins.

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    If you want to provide db for analysis, follow instructions at bottom of my post.
    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.

  9. #9
    JohnLouisWood is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Mar 2023
    Posts
    52
    I think I got things to work fine. I was able to get my v2 data onto the v4 query.
    I then had many text boxes, with conditional statements to complete the final line of the sub-report.

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

Similar Threads

  1. Replies: 14
    Last Post: 05-14-2020, 12:24 PM
  2. Multiple days data on a single line
    By Keshka in forum Reports
    Replies: 1
    Last Post: 07-13-2016, 01:48 PM
  3. Replies: 7
    Last Post: 06-04-2013, 01:10 PM
  4. Replies: 4
    Last Post: 11-07-2012, 09:59 AM
  5. Replies: 0
    Last Post: 11-23-2009, 09: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