Any idea on showing a filtered data description on form

[xaxier]

Hi guys,

I am currently experimenting with Access and I would like to create a feature where user can check on their number of task based on their updates. I have currently created a form where it can capture user NT login and filter the task based on the user NT login

For example, User A just completed 20 out of 120 of his task. Can this kind of statement appear on the form

Total task : 120
Remaining task: 100


Thanks

 

[Galaxiom]

Place a textbox in the footer or header and use the control source:
=Count(somefieldname)

It will only count values that are not Null so use this fact to get the two different figures. Arithmetic can be used in the control source.

Use either a single or continuous form which will allow header/footer to display. If you really want your form in datasheet mode then move it into a subform and refer to the textboxes from a control on the main form to display the values.