Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2006
    Posts
    3

    Unanswered: Report Format Help

    Hi, i have a table that looks like so

    period, A, B, C, D, E, F..........

    but need it to be displayed in a report in the following format
    ________Period1, Period2, Period3,...........
    A
    B
    C
    D
    E
    F

    Does anyone know how i can go about doing this? Thanks.

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372

    Hello rivacam!

    1) You have to learn something about DATABASE NORMALIZATION.
    your table is not normalized.
    2) Is there any other field after "F" (how many)?
    3) Is there any data in A, B....... field?
    4) Is there a PRIMARY KEY in table?

  3. #3
    Join Date
    Jul 2006
    Posts
    3
    The table used an example above is a make table brought together from three smaller tables each using a primary key, each of the smaller tables consist of approximately 6 fields which all need to be brought together to be shown in the report format that i have shown above, each field contains data whether it be production figures, operating $, and capital $s associated with the period

  4. #4
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Let me know how this 3 tables looks like.
    Maybe I can to do something.

  5. #5
    Join Date
    Jul 2006
    Posts
    3
    Volumes table

    Key Period NBR (MMCF) RR NAR NBR /d NAR / d
    1 01 1243 0.12 1093.84 40.09677419 35.28516129
    2 02 1345 0.11 1197.05 43.38709677 38.61451613
    3 03 1612 0.13 1402.44 52 45.24
    4 04 1423 0.1 1280.7 45.90322581 41.31290323
    5 05 1210 0.13 1052.7 39.03225806 33.95806452
    6 06 1164 0.13 1012.68 37.5483871 32.66709677

    Operating $ Table

    Key Period Chemicals Electricity Gas Gath / Proc Chgs Other Direct Overhead
    1 01 1,976.95 8,155.94 26,665.43 79,366.76 7,767.08
    2 02 46,553.10 29,477.48 373,967.75 74,647.58 8,798.19
    3 03 16432.49 11444.65 352118.07 81864.49 20332.3
    4 04 14041.58 14758.15 153121.4 48479.33 14817.15
    5 05 10641.06 11435.11 158179.94 51948.32 16214.44
    6 06 0 0 0 0 0

    Captial

    Key Period Completions Drilling Facilities G & G Land
    1 01 8560718.19 11512219.74 2799631.96 1440794.44 2421.44
    2 02 6042307.65 13073233.82 11798421.84 1342379.9 0
    3 03 3572104.02 7104754.41 19847876.29 -9614.81 0
    4 04 6761207.76 4875940.54 2267291.25 725926.6 0
    5 05 1878620.26 4097629.27 -49341.18 292723.38 1500
    6 06 0 0 0 0 0

    Thanks for your help

  6. #6
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    I stil don't understand you. In your tables I can see PERIOD,
    but, what is "A", "B".......and s.o.

  7. #7
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    What you want is a crosstab query. In the query design grid choose your table. Although it doesn't look like it will work with the three tables you have made. Hopefully you can do the Crosstab before the tables are made. If your data looks like:

    Key Period Description Value
    1---01----Chemicals--1,976.95
    1---01----Electricity--1,976.95
    .
    .
    .
    etc.

    Then a crosstab is ideal. In this scenario, in query design add the table, then add the Period, Description and Value. THen change the query to a Crosstab and make Period the Column Heading, Description the Row Heading, and Value the Data (doing a sum on the Value). This should give you the format you need.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •