[turbodante]

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.

[OBP]

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.

[OBP]

Here it is.

[turbodante]

Thanks for looking at this, OBP.

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

[OBP]

Like this?

[turbodante]

You the man OBP. Thank you - I'll try reverse engineering it to understand what you've done.