S
SMatthew
Happy New Year John!
What I am trying to do is write an application - " To do
list for all employees according to the Priority
Level"(A,B,C.). When the task is completed the Priority
level has to be removed from that task and list has to be
reassigned according to the priority date.
For example:
Name priority date Priority Level
1. Tom 12/31/03 A
2. Tom 01/02/2004 B
3. Tom 01/04/04 C
4. Henry 01/02/04 A
5. Henry 01/05/04 B
So when Tom finishes his 1st task the priority level is
reassigned
Name priority date Priority Level Date Completed
1. Tom 12/31/03 12/31/2003
2. Tom 01/02/2004 A
3. Tom 01/04/04 B
4. Henry 01/02/04 A
5. Henry 01/05/04 B
In order to do this would I be able to do this as a
Calculated field in a query , if so how, If not please
would you be able to give me any suggestions.For now I
would like to handle just alphabet increment from A- Z.
Thanks in advance
SMatthew
-------------------------------------------------------
Subject: Re: Calculated field (text) in query
From: "John Vinson"
<jvinson@STOP_SPAM.WysardOfInfo.com> Sent: 12/31/2003
10:18:04 AM
You'ld need to use a custom VBA function. Could you post
some more
details? What exactly are you trying to accomplish? Will
there be more
than 26 records, and if so what do you want to see (AA,
AB, AC, ... or
what)?
..
What I am trying to do is write an application - " To do
list for all employees according to the Priority
Level"(A,B,C.). When the task is completed the Priority
level has to be removed from that task and list has to be
reassigned according to the priority date.
For example:
Name priority date Priority Level
1. Tom 12/31/03 A
2. Tom 01/02/2004 B
3. Tom 01/04/04 C
4. Henry 01/02/04 A
5. Henry 01/05/04 B
So when Tom finishes his 1st task the priority level is
reassigned
Name priority date Priority Level Date Completed
1. Tom 12/31/03 12/31/2003
2. Tom 01/02/2004 A
3. Tom 01/04/04 B
4. Henry 01/02/04 A
5. Henry 01/05/04 B
In order to do this would I be able to do this as a
Calculated field in a query , if so how, If not please
would you be able to give me any suggestions.For now I
would like to handle just alphabet increment from A- Z.
Thanks in advance
SMatthew
-------------------------------------------------------
Subject: Re: Calculated field (text) in query
From: "John Vinson"
<jvinson@STOP_SPAM.WysardOfInfo.com> Sent: 12/31/2003
10:18:04 AM
In Access 2002 would you be able to use a calculated
field in a query and increment Alphabets (A,B,C...)
Please help!
You'ld need to use a custom VBA function. Could you post
some more
details? What exactly are you trying to accomplish? Will
there be more
than 26 records, and if so what do you want to see (AA,
AB, AC, ... or
what)?
..