query assistance

[LG]

I am have to find out a %, based on total(# of records)-
corrections/total(# of records)
The fields i have would be QCP_id, date, batch_id, and correction.
I would need to get the total amount of records by QCP_ID, using the count
of the batch_id, and I guess the same for the correction with= to y.
Am I in the right direction? But than I dont' know where to go from there.
Once I get this part than I have to build the join query for all the tables.
Thanks

 

[Jeff Boyce]

While you can absolutely use an Access query to do this kind of calculation,
is there a reason you aren't just using Excel?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[LG]

There are many other fields associated in the table to other things. These
are just the fields I will be pulling out to track this data. Prior it was
done by hand and manually counted in excel. Would the better way to get the
total number of records and the total number of corrections and than do the
calculations? Is that what you meant?

 

[Jeff Boyce]

Sorry, didn't follow your description.

If you are only 'counting', Excel does that well. If you are making use of
relational database features/functions, Access does that well.

Regards

Jeff Boyce
Microsoft Office/Access MVP