Computing.Net > Forums > Database > Possibly Easy Access Question

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

Possibly Easy Access Question

Reply to Message Icon

Name: UltimoDragon
Date: July 13, 2006 at 07:40:26 Pacific
OS: Windows 2000
CPU/Ram: n/a
Product: 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?



Sponsored Link
Ads by Google

Response Number 1
Name: Tanis
Date: July 14, 2006 at 00:19:18 Pacific
Reply:

Try something like this

SELECT ([Amount]/[Quantity]) AS Percentage
FROM tblYourTable;


David


0
Reply to Message Icon

Related Posts

See More


Access question Starting SQL



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Possibly Easy Access Question

MS Access Question www.computing.net/answers/dbase/ms-access-question/63.html

Access Question www.computing.net/answers/dbase/access-question/12.html

Access 2000 Compact and Repair www.computing.net/answers/dbase/access-2000-compact-and-repair/364.html