I have a table of information, including a status field. What I have so far is a list with a calculated field for each existing status for a given grouping. Example:
FieldA | FieldB | Status | Count
201 | 305 | 10 | 150
201 | 305 | 20 | 106
And so on. What's straining my head is trying to get each separate count into a different field into another table in one sweep. If I had the luxury of SQL Server (which I don't), making a stored procedure would be pretty simple. AFAIK
, Access doesn't give me such creature comforts.
That said, is there any way I can parse out each field in one sweep, or will I have to do some more hoops-jumping?