Results 1 to 2 of 2
  1. #1
    AnthonyT is offline Novice
    Windows XP Access 2003
    Join Date
    May 2009
    Posts
    3

    Help reqd with Count of Similar Vals

    Hi there

    Have a DB that records Business Opportunities and deals. Each opportunity can lead to several deals but at present there is only a deal ID and no Opportunity ID exists.

    Need to ID number of Opportunities in TblDealData.

    An opportunity would have the same: CustID, Start_Date, End_Date, Deal_Size_Min, Deal_Size_Max

    But Diff Trade_IDs



    Have tried a select query and group by each of the above and finanly got a Count on Deal_Size_Max but figs not correct

    Any ideas?

    Thanks

  2. #2
    CraigDolphin is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Apr 2009
    Location
    Custer, WA, USA
    Posts
    125
    This should be relatively trivial assuming your database is set up correctly.

    You have a simple one to many relationship between oppotunities and deals right?

    So, based on what you stated in your OP, your table structure should have the following two tables:
    tblOpportunities
    OpportunityID (auto, pk)
    CustID (fk)
    StartDate
    EndDate
    DealSizeMin
    DealSizeMax

    tblDeals
    DealID (auto, pk)
    OpprtunityID (fk)
    TradeID (fk?)

    Along with table listing Clients, and possibly also Trades depending on exactly what is represented by the TadeID field.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. remove record count
    By theITguy in forum Access
    Replies: 1
    Last Post: 03-06-2009, 06:22 PM
  2. using COUNT for multiple tables
    By kwalt in forum Queries
    Replies: 0
    Last Post: 02-17-2009, 03:06 PM
  3. Query using count function
    By wasim_sono in forum Queries
    Replies: 0
    Last Post: 11-28-2007, 03:16 AM
  4. Form Record Count
    By Texaine in forum Forms
    Replies: 0
    Last Post: 10-19-2006, 09:07 AM
  5. Count and recount for every new user per day?
    By valkyry in forum Queries
    Replies: 0
    Last Post: 07-24-2006, 03:37 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums