Solved: Access, a calculation/report

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

turbodante

Thread Starter
Joined
Dec 19, 2008
Messages
744
I’d like to know how, if possible to do in Access, a calculation:

I have a 30,000 lines of data. Each line contains, amongst other stuff - a Sitecode, ItemCode, date, value and flag.

Each SiteCode can be categorised by it’s prefix letter A,B,C
ItemCodes are TSGxx where xx is 01 to 99

The Flag only appears when a certain value is exceed, but as far as where I’m taking this – we needn’t give further thought to the value as the flag is coded in the data.

My question is, is it possible for Access to report/query on the percentage % of each code (A,B,C...), The ItemCodes that have been not been flagged

Have attached sample excel for which the data is to exported to Access.
 

Attachments

OBP

Joined
Mar 8, 2005
Messages
19,895
Yes Access can do this, it may be possible with one, but may take 2 queries. One to count and one to calculate the percentage.
 

turbodante

Thread Starter
Joined
Dec 19, 2008
Messages
744
Thanks for looking at this, OBP.

Can the same calc be applied by item code? - and how is it done?
 

turbodante

Thread Starter
Joined
Dec 19, 2008
Messages
744
You the man OBP. Thank you - I'll try reverse engineering it to understand what you've done.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top