Page creation

[meliss421]

I need to create a page/table or form that allows two users to be in it and the same time to log in assignments they have assigned. Example we have 5 people that recieve assignments, I want a tick mark or some type of entry showing under their name everytime a file is assigned to them.


Is this possible?

[rpeare]

This is a very vague question.

Can you be more specific about your process, for instance are you attempting to log whoever is modifying a record, or are you attempting limit what your users see to what they are responsible for or something else entirely?

[meliss421]

sorry, let me clarify
we have an assignment log, 4 people get assignments daily, two people assign them at the same time. i wanted to create something so the two assigners can be in it at the same time and pick a tick mark or something to that effect under the desk so 4 people get the same or similar amount of assignments.

[rpeare]

So the problem is not being able to assign items to specific people, it's that you want some sort of indication of how many open assignments a person has so that the person doing the assigning doesn't give one person 10 and another person 0 assignments?

[meliss421]

yes that is what i am looking to create.

[rpeare]

Can't you just do an aggregate query (in your query design there should be a Sigma button (greek letter that looks like a capital E). This will add a TOTALS line to your query down in the section where the CRITERIA row is located. Create a query that has all of your employees who receive assignments on it and use the COUNT function to count their active assignments. Then just have that query display on your form (either through a list box or subform displaying the query itself) and perform a requery of that subform or list box every time your data is updated.

[meliss421]

I am know basic access so i wasnt sure if this was capable to not. ok will try that. thanks for your help.