I am a just a little more than a novice in Access but I can’t figure this one out: I have a table in Access where one field (text) of a table contains document numbers. Each entry (a combination of 12 letters and numbers) contains a document type identifier separated by “-“, e.g. -A-, -M-, -Y-, etc. I need to put together a query which will give me the total number of documents for each of the 8 document types. Can anyone help me?
Thank you,
zdjbel
