Results 1 to 2 of 2
  1. #1
    Lynn is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    25

    Percentage Calculation in a Query

    Hi,
    I'm not sure why I can't seem to get this right...in my query I have a "Contact Title" field which I'm filtering so that only "Physician" records show and then another field that counts the physician records. I want to then show the percentage of just physician records to all records. I can't get the overall record count. What am I doing wrong?
    Lynn

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    well difficult to say where you are going wrong as I don't know the syntax of you query:

    an Example suppose I want to finf % of member record the I would do some thing like this:

    Create a calculative Field:

    percentage: Dcount("[MemberId]","tblMemberRecord","[MemberId]=" & [tblMember].[MemberID])/Dcount("[MemerId]","tblMemberRecord"))*100.

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

Similar Threads

  1. How to calculate a percentage on form
    By jrockusa in forum Forms
    Replies: 1
    Last Post: 03-31-2010, 01:53 PM
  2. Query Calculation
    By kellyd in forum Queries
    Replies: 5
    Last Post: 08-31-2009, 11:14 AM
  3. Use report to Calculate sum and percentage
    By bangemd in forum Reports
    Replies: 3
    Last Post: 05-28-2009, 12:01 PM
  4. Percentage Queries
    By bangemd in forum Queries
    Replies: 18
    Last Post: 05-21-2009, 09:32 AM
  5. percentage in a query
    By Peljo in forum Access
    Replies: 2
    Last Post: 02-27-2008, 10:51 AM

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