Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: psdcc
  • Order by date
  1. psdcc

    Convert records into fields?

    Hi all, I have inherited a customer table that has 33 pieces of information for each customer (250 customers). Consequently, the table ends up having around 9000 records. I would like to modify the table so that it has a single record for each customer and a field for each piece of...
  2. psdcc

    Graphs using records......

    Thanks dhookom....I played around with the data in Excel, transposed it and then reloaded into Access and it all worked. But, I'd like to try rearranging the data using the union query as you mentioned. What is involved in doing that? At the moment all the data is in three fields in one...
  3. psdcc

    Graphs using records......

    Wonderfully, I am now able to do bar charts and scatter graphs quite easily but I am having a tougher go at pie charts. At the moment, I have three fields that are a percentage of 100. For example, Field A = 30%, Field B = 60%, Field C = 10%. In the Pie chart, I am only given the option of...
  4. psdcc

    Graphs using records......

    Ah ha! I gave it another shot and was able to add additional fields. Absolutely Brilliant. I knew it was something blatantly obvious.....I'm glad I found this forum!!!! Thanks again for all the help! psdcc
  5. psdcc

    Graphs using records......

    Wow!!! Excellent, I actually got a graph to work for each client!! My problem has apparently been setting the master/child links. I have an additional question and I think I just have to rearrange my thinking.. In excel, I can create a graph using data in 4 fields as my data source. When I...
  6. psdcc

    Word Mail Merge, Access Tables and Graphs

    This has been bothering me for a while... I've created a report for every client by making a template in Word, inserting the Access Fields and then hitting mailmerge. What I would also like to do is have a graph created using fields from the same Access table. The graph would change along...
  7. psdcc

    Graphs using records......

    I apologize for what is likely a blazingly obvious question, however it continues to plague me.... I only have MS Office package installed, so other applications like Crystal Reports aren't available to me. I have a set of tables with highly summarized datafields. Each record represents one...

Part and Inventory Search

Back
Top