• Produce Blank lines in Report (Access 2k_SR-1)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Produce Blank lines in Report (Access 2k_SR-1)

    Author
    Topic
    #389829

    I have a report that groups Categories,

    If I don’t have any records for CAT01 or CAT02, how can I still produce a blank line in the report for those categories?

    Thanks

    Viewing 0 reply threads
    Author
    Replies
    • #690265

      The basic idea is that you have to base the report on a query with a left join between (a table or query returning unique categories) and (the rest of the data). The left join forces the query to return ALL categories regardless of whether they contain data. How exactly to organize this, depends on the tables and queries you already have.

    Viewing 0 reply threads
    Reply To: Produce Blank lines in Report (Access 2k_SR-1)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: