query that generates percentages

[jppevy]

How do you generate a query that includes percentages? I have a table with 3 columns. There are three different types (avail, out, low) and 4 different groups (1,2,3,4) . For each group (e.g. 1), I want to find out what percentages are avail, what percentages are out, and what are low. How can i create a query for this?

ID	Type	Group
1	avail	1
2	avail	3
3	out	2
4	low	1
5	out	4

Thanks again!

[June7]

Options:

1.
build an aggregate GROUP BY (Totals) query that counts the types for each group
build an aggregate GROUP BY (Totals) query that counts all records
join those two queries without using a join clause, every record will have the total from the second query
calculate percentage in the second query

2. use DCount() expression in the first query to do the count of all records

3. build a report using report Grouping & Sorting with aggregate calcs in group and report footers

[jppevy]

Can you explain the 1st and 2nd option again in more detail. I am new to access and find it a bit unclear. Thank you for the help.

[June7]

Hard to give specifics not knowing your db.

I don't want to repeat the Access Help reference. It has guidelines on building aggregate (grouping) queries with the query designer as well as on domain aggregate functions (DSum, DCount, DLookup, etc).

Aggregate query is basic Access functionality. Domain aggregate functions are a little more advanced tool but covered in Help.