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?

I am not exactly sure of the math you are doing with these fields. What I can tell you is that Access can do what SQL stored procedures do.

What you need to do is to store basic data in one table, then create a query that does your caluclations and store the result of those calculations in that query (well, not really stored). Then you can write a function or sub that moves the results of that query to another table, if for some reason you want the calculations stored in another table, which they shouldn't be, except perhaps for archiving, or if the database is very large, for OLAP.

If you can provide the basic (calucalted on) fields and table structure, I am sure we can get the calculations you want, and the procedure for moving the query results to another table.

HTH


mmcdonal