Search results for query: *

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...

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...

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...

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

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...

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...

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...