You want this for one table and you apply it to the others? Or are you going to join each table by EmpNo (using special characters = bad). Only exception is underscore.
I bet you could make use of these pages sooner or later:
http://allenbrowne.com/AppIssueBadWord.html
http://access.mvps.org/access/general/gen0012.htm
I taught myself to use some different versions (such as cmb for combo) rather than look these up every time in my early days. What really matters is that you adopt something that others should be able to follow and be somewhat consistent.
AND normalization: the below sample should be derived from 2 tables, not 1. If this were a query result, OK. As a table, you should not be repeating the infraction itself, rather a Primary Key from tblInfractions. Infractions are one thing, Employees are another, departments another and so on. Keep them separate and bring them together only in forms or reports. If you have a spreadsheet mentality (stuff in columns) better learn the database (rows) mentality. Start here, but go beyond https://support.microsoft.com/en-ca/kb/283878
After all that, your meaning of format might be different than my understanding. I don't get any clues as to what you desire in terms of formatting. If your example is too simplified and unrelated to what you really want, that approach often poses problems for us trying to help. One last thing re: removed spaces. Use code tags or copy/paste small sections of Excel spreadsheets like this
tblElectronics |
|
|
|
EmplNo |
Infraction |
Total |
|
01 |
Spitting |
3 |
|
01 |
Swearing |
6 |
|
02 |
Spitting |
1 |
|
02 |
Tooting |
3 |
|
02 |
Having fun |
5 |
PS: I would get rid of employee 02. He looks like trouble.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.