Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

need conceptual table design direction

Discussion in 'Information Technology' started by mark kubicki, Jul 28, 2006.

  1. mark kubicki

    mark kubicki
    Expand Collapse
    Guest

    I have a table with an undetermined number of records...
    typically, I have "a" report that prints all of the records in the table

    I need to set up an undetermined number of additional versions of the report
    (query...) where only prespecified records of the table are included, the
    only criteria for a record to be included would be by the user's random
    choice -there would be no data determined criteria (ex: not everyone who
    lives in "New Jersey" just the folks I designate as living there, or who I
    think live there, or who I think ought to live there)

    ex:
    report001-version_A - include records: 1, 2, 3, 4, 5
    report001-version_B - include records: 1, 3, 5
    report001-version_C ....

    if this were a spread sheet, I would have all of the records listed in rows,
    and then each time I added a version of the report, I would add a new column
    for it, if a record were to be included in that report, I would enter a "Y"
    the intersecting field, else an "N" (this also allow me to compare which
    records were being included in different versions of the reports while also
    giving me a comprehensive look at what was being included in the report I
    was currently choosing for...

    in Access, i'm lost

    (great at Excel, O.K. enough at VBA, not so O.K. at ACCESS)
    thanks in advance,
    mark
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News WWI Sikh Heroes Need To Be Remembered: Dr Atamjit Breaking News Sep 11, 2016
    Interracial And Interfaith Marriage, Help Needed To Confront/convince My Parents Love & Marriage Aug 16, 2016
    Sikh News Sikh Seva Volunteers Keep The Food Service Drive For The Needy Going After Passing Away Of Breaking News Jul 29, 2016
    Need some info regarding bibek wrt eating Sikh Rehat Maryada Jan 14, 2016
    Spiritual Why We Only Need To Pray For Naam Blogs Dec 20, 2015

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    One way to do what it sounds like you want is to add a flag column - MyPrint.
    Then in the query for the report set criteria to print all that you have
    flagged.
    Then run an Update query to remove the flags before starting next time.

    "mark kubicki" wrote:

    > I have a table with an undetermined number of records...
    > typically, I have "a" report that prints all of the records in the table
    >
    > I need to set up an undetermined number of additional versions of the report
    > (query...) where only prespecified records of the table are included, the
    > only criteria for a record to be included would be by the user's random
    > choice -there would be no data determined criteria (ex: not everyone who
    > lives in "New Jersey" just the folks I designate as living there, or who I
    > think live there, or who I think ought to live there)
    >
    > ex:
    > report001-version_A - include records: 1, 2, 3, 4, 5
    > report001-version_B - include records: 1, 3, 5
    > report001-version_C ....
    >
    > if this were a spread sheet, I would have all of the records listed in rows,
    > and then each time I added a version of the report, I would add a new column
    > for it, if a record were to be included in that report, I would enter a "Y"
    > the intersecting field, else an "N" (this also allow me to compare which
    > records were being included in different versions of the reports while also
    > giving me a comprehensive look at what was being included in the report I
    > was currently choosing for...
    >
    > in Access, i'm lost
    >
    > (great at Excel, O.K. enough at VBA, not so O.K. at ACCESS)
    > thanks in advance,
    > mark
    >
    >
    >
     
  4. Mark J Kubicki

    Mark J Kubicki
    Expand Collapse
    Guest

    almost
    except that one version of the report DOES NOT supersede the previous,
    multiple versions may exist at the same time, so each record needs to know
    which report it is included in and which it is not... I could add a flag
    column for each version of the report, except the number of reports is
    unknown.



    "KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message
    news:73626690-0663-4D81-AC1B-6F46D1F8790C@microsoft.com...
    > One way to do what it sounds like you want is to add a flag column -
    > MyPrint.
    > Then in the query for the report set criteria to print all that you have
    > flagged.
    > Then run an Update query to remove the flags before starting next time.
    >
    > "mark kubicki" wrote:
    >
    >> I have a table with an undetermined number of records...
    >> typically, I have "a" report that prints all of the records in the table
    >>
    >> I need to set up an undetermined number of additional versions of the
    >> report
    >> (query...) where only prespecified records of the table are included, the
    >> only criteria for a record to be included would be by the user's random
    >> choice -there would be no data determined criteria (ex: not everyone who
    >> lives in "New Jersey" just the folks I designate as living there, or who
    >> I
    >> think live there, or who I think ought to live there)
    >>
    >> ex:
    >> report001-version_A - include records: 1, 2, 3, 4, 5
    >> report001-version_B - include records: 1, 3, 5
    >> report001-version_C ....
    >>
    >> if this were a spread sheet, I would have all of the records listed in
    >> rows,
    >> and then each time I added a version of the report, I would add a new
    >> column
    >> for it, if a record were to be included in that report, I would enter a
    >> "Y"
    >> the intersecting field, else an "N" (this also allow me to compare which
    >> records were being included in different versions of the reports while
    >> also
    >> giving me a comprehensive look at what was being included in the report I
    >> was currently choosing for...
    >>
    >> in Access, i'm lost
    >>
    >> (great at Excel, O.K. enough at VBA, not so O.K. at ACCESS)
    >> thanks in advance,
    >> mark
    >>
    >>
    >>
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 8 May 2006 21:43:45 -0400, "Mark J Kubicki"
    <mark.kubicki@verizon.net> wrote:

    >almost
    >except that one version of the report DOES NOT supersede the previous,
    >multiple versions may exist at the same time, so each record needs to know
    >which report it is included in and which it is not... I could add a flag
    >column for each version of the report, except the number of reports is
    >unknown.


    Use one RECORD per value - not one FIELD per value.

    You need a third table with two fields - ReportNo and RecordNo. If
    Report AAB contains records 1, 3, and 5, this table would have three
    records:

    AAB 1
    AAB 3
    AAB 5

    Base the Report on a query joining this table to the table containing
    the records.

    John W. Vinson[MVP]
     

Share This Page