Verify data after certain entries

[maabbas]

Is there any way user can verify the data that its enter correctly, for example I want a button on user form, after every 14 entries when user hit that button it bring the sum of 14 entries.

Any help will be greatly appreciated.

 

[BlueIshDan]

You're going to have to provide more information on this one.

Regards,
BlueIshdan

 

[maabbas]

I have a MSACCESS form "ProductionForm" based on query, form has following fields.

Production Date
Product Code
Product Description
Employee ID
Employee Name
Lbs Produce

We have more than 300 employees and they produce approximately 15 different products during the day. The data collection in production floor is simple, whenever the container full with the product, they weigh on scale and write down on simple paper form, the paper form structure I explain in above reply ( has 15 blank column where column header has employee name and below we write down their lbs produce each time the container full, the last column had total for 14 employees). Now from that paper sheet we enter data in MSACCESS above form to create reports and payroll.



I want to make a query which give me the sum of 14 employees lbs produce, or I can say total of new records.

 

[maabbas]

I have a MSACCESS form "ProductionForm" based on query, form has following fields.

Production Date
Product Code
Product Description
Employee ID
Employee Name
Lbs Produce

We have more than 300 employees and they produce approximately 15 different products during the day. The data collection in production floor is simple, whenever the container full with the product, they weigh on scale and write down on simple paper form, the paper form structure I explain in above reply ( has 15 blank column where column header has employee name and below we write down their lbs produce each time the container full, the last column had total for 14 employees). Now from that paper sheet we enter data in MSACCESS above form to create reports and payroll.



I want to make a query which give me the sum of 14 employees lbs produce, or I can say total of new records.

any help from you guys?

 

[JHB]

...
I want to make a query which give me the sum of 14 employees lbs produce, or I can say total of new records.

How you determine which records that belong together, (new/old)?
Could you show some sample data in a Excel sheet or MS-Access database table?

 

[GinaWhipp]

This was discussed here...
http://answers.microsoft.com/en-us/...d=b959f28b-52bd-4fbd-a777-76a1e392e7d6&page=1

Are you saying you did not understand the suggestion of Groups and Totals query. I posted a link that discussed it.