none
Grouping records in VBA RRS feed

  • Question

  • I may have some issues with grouping records.

    I have a sample table.

    Here are the attributes:

    RecID, RecordTitle, EntryID

    What I want my program to do is the following:

    1. Add a running calculation for the RecID.

    2. Group the records by EntryID while running calculation is in progress.

    For example:

    A user inputs 100 for EntryID while a running calculation is in place.

    If a user inputs other than 100 for EntryID, a new grouping for EntryID automatically begins while

    a running calculation for RecID is still in progess.

    RecID   RecordTitle    EntryID

    1          Record01      100

    2          Record02      100

    3          Record03      200

    4          Record04      200

    5          Record05      100

    6          Record06      100

    This may be hard to explain for some users, but this may require some VBA coding.

    Regards,

    JohnDBCTX


    jp

    Saturday, February 4, 2017 2:16 AM