Welcome to SPN

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

Sign Up Now!

Sales Lead Form Query

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

  1. Pete

    Expand Collapse


    I work for a company wholesale manufactures a product in high demand. We
    don't sell to the end user.

    We get a number of "Mum & Dad" sales leads that come in via our website &
    yellow pages adverts that we want to forward onto our agents for them to

    I have an Excel spreadsheet with all our agents contact details listed.

    I want to be able to run a sales lead summary that lists by agent, the
    contact details of all the leads for a date range e.g. 1st April 2006 until
    22nd May 2006.

    Ideally, I would type into an Access form:

    1. the agents name & a date range, hit enter & have the sales leads come up
    in an excel spreadsheet.

    2. Date range & have the total number of leads for that period come up in an

    Is this doable in Access?

    How would I go about this?


  2. Loading...

    Similar Threads Forum Date
    Asian Stocks Gain On US Retail Sales Gain; Sony Leads Advance Interfaith Dialogues Dec 14, 2004
    Ashdoc's Movie Review---The Salesman ( Iranian Film ) Theatre, Movies & Cinema Apr 14, 2017
    USA Sikh Car Salesman Reaches Settlement With Lexus Dealership Breaking News Nov 30, 2013
    Luxury Car Sales Boom In Punjab, Haryana Business, Lifestyle & Leisure Aug 27, 2011
    India Tata Nano's Nov Sales One-sixth Of Oct Figures Breaking News Dec 7, 2010

  3. OP

    Expand Collapse

    You will need to transfer the Excel data to a table in your database
    and then set up several queries to obtain the data that you need. From
    the queries you can export to Excel. The table that you transfer the
    data to may be linked to your Excel data, however, it would be better
    if the data was located in Access as you can have the information
    updated, view a history of the data, query-as-you-wish data and export
    any resulting query to Excel (since the last quarter of 2005 you can
    not link Access data to Excel due to some patent lawsuit but you can do
    it the other way around).
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page