Possibly Easy Access Question

Original Message

Name: UltimoDragon
Date: July 13, 2006 at 07:40:26 Pacific
Subject: Possibly Easy Access Question
OS: Windows 2000
CPU/Ram: n/a
Model/Manufacturer: n/a

Comment:

Okay, here's the deal. Let's say I have a column of numbers.
A 2
B 3
C 5
I want to create a calculated field in a query that finds the percentage of the total. For example:
A 20%
B 30%
C 50%
How do I accomplish this?

Report Offensive Message For Removal

Response Number 1

Name: Tanis
Date: July 14, 2006 at 00:19:18 Pacific

Reply: (edit)

Try something like this
SELECT ([Amount]/[Quantity]) AS Percentage
FROM tblYourTable;

David

Report Offensive Follow Up For Removal


MS Access Question Access Question Access 2000 Compact and Repair Access question Access Query to Merge with Word Doc	Import Multiple *txt in Access Linking Access tables over Internet attaching files/linking in access Access/Word Merge Problem - Help! SQL 2005 UNION question

Access question

Starting SQL

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Possibly Easy Access Question

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL: