• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Access dbase Q

A

AmerDoux

Senior member
I have student school attendance table in Access. I need to be able to subtotal the number of occurrences of a specified text by row (ex: number of "A" occurring on a row).
I understand how this is done by field/column.
I need to have this set up so there is another column in the query that displays the requested subtotal, student row by student row.
I have tried this as a DCount aggregate function, but am getting syntax errors.
Can anyone help me out with an example SQL statement?

Thanks!
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top