Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    USA
    Posts
    66

    Unanswered: query analysis question

    Greetings,

    I've successfully imported XML data into Excel and Access (attempted to attach the striped version of the db in access)

    I was trying to accomplish the following:

    1) average invoice total amount for application fees only, broken out by division, for the third quarter of this year.
    2) Using the relational database, create a deduped mailing list for as many current and complete addresses as possible. Submit the mailing list as an XML file.
    3) Create a reader-friendly report break out the following statistics:
    a. Total number of currently accredited sites
    b. Total number of applications in process
    c. Number of labs that have achieved accreditation in multiple divisions
    d. Total number of sites granted accreditation in each app area
    e. Average number of sites per application

    I'm using office 2007, and would like to know the best way to accomplish these (Excel or Access)...and some guide. ?

    Thanks,

    OCM

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    First: Is it Excel or Access?
    If it's Access:
    Second: What are the structures of the data (number of tables, names and data types of the columns, relationships if any, etc...?
    Third: What do you have so far?
    Fourth: What is the problem you cannot solve or the occuring error you do not understand?

    Without this information I seriously doubt anybody here would be able to help you.
    Have a nice day!

Posting Permissions

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