Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by commonskills

  1. commonskills

    Calculating percentages in Access 2003

    SELECT DISTINCTROW Count([EQUAL OPPORTUNITY])/ Count(TOTAL) AS [%] FROM [HQ CO TRNG DATABASE]; got it Thanks!!!!
  2. commonskills

    Calculating percentages in Access 2003

    CountOfEQUAL OPPORTUNITY CountOfTOTAL 35 211 This is what the fields look like, im not certain if this is helpful in solving this but it 35 have take the class out off a possible 211 people
  3. commonskills

    Calculating percentages in Access 2003

    SELECT DISTINCTROW Count([HQ CO TRNG DATABASE].[EQUAL OPPORTUNITY]) AS [CountOfEQUAL OPPORTUNITY], Count([HQ CO TRNG DATABASE].TOTAL) AS CountOfTOTAL FROM [HQ CO TRNG DATABASE]; Thanks Duane MS Access MVP, PHV, and Skip!!!!!!!!!!!!!
  4. commonskills

    Calculating percentages in Access 2003

    what does "enter a parameter" mean?
  5. commonskills

    Calculating percentages in Access 2003

    does this look right: select Count([CLASSES DATABASE].TOTAL)/Count(*) AS [%] [COUNTOFTESTTAKEN] FROM [MASTER CLASS DATABASE]; Thank you
  6. commonskills

    Calculating percentages in Access 2003

    Thank you for your time, I'm doing the Count([Take Test])/Count(*) AS [%] expresion in design view of a query, under the Criteria tab, in expression builder, is that correct? I made the database in about two days but Ive been working on the percentages for about a week now. I have a...
  7. commonskills

    Calculating percentages in Access 2003

    Thank you, I have a table that looks something like this: Students Taken Test 1 20071201 2 20071201 3 20071205 4 20071205 5 20071205 6 20080108 7 blank 8 blank This is multipled by 100...
See more

Part and Inventory Search

Back
Top