Allocate Record by User

[blue2kuk]

Hi All

I want a user to click a button and then it will assign the oldest record in the table to that particular user, by using their NT login.

Anyone got any suggestions?

Thanks

 

[Pat Hartman]

query1:
Select Top 1 RecKey, TranDate, NTLogon
From YourTable
Where NTLogon Is Null
Order by TranDate descending;

query2:
Update query1
Set NTLogon = Forms!YourFormName!NTLogon;

Run query2 in the button click event.

 

[blue2kuk]

query1:
Select Top 1 RecKey, TranDate, NTLogon
From YourTable
Where NTLogon Is Null
Order by TranDate descending;

query2:
Update query1
Set NTLogon = Forms!YourFormName!NTLogon;

Run query2 in the button click event.

Pat,

Thank you for your response.

I am ok with most of the code, however, having problems with "Select Top 1 RecKey, Trandate, NTLogin.

What does this mean as the system will not reconise RecKey

Thanks

 

[blue2kuk]

Pat,

I have worked it out, it works wonders when you look at it in simple terms.

Many Thanks for your help.

Regards

Blue2kuk

 

[blue2kuk]

Hi

I would also like the query to also assign any records with the same account number which are outstanding to the same user.

Is there a way that this could be done?

 

[Pat Hartman]

You will need to do that in a separate query.