Can Asswss help with....?

H

Hec Jacobson

Hello to all that reads this and thank you in advance for any help you guys
can provide. I have just a question, The question is in the database that i
created, I have 2 calendars to track people when they leave for busniess
trips. One calender when they start, and the second calender when they come
back.. They have up to 5 days to complete their travel claims before it
becomes over due. I want to know how I can automatically track after they
come back the 5 days as far as the over due claim. I want to have Access
automatically tell me "this person is 5 days over due.." without having to
creat a YES/NO field and manuallycheck it in. Can you guys tell me how this
can happen? If it cant happen like that, can you guys tell me how I can get
it as close as possible. Thanks for the help.
 
D

Douglas J Steele

Create a query with a computed field that determines whether their claim is
overdue and use the query wherever you would otherwise have used the table.

Since I don't know what your exact table definition is, I can only
approximate what the computed field would be like:

OverdueDays: IIf([Processed] = True, "", IIf(DateDiff("d", [DateReturned],
Date()) > 5, "This person is " & DateDiff("d", [DateReturned], Date()) & "
days over due", ""))
 
H

Hec Jacobson

Thank you Mr. Steele for your help.

Sorry if I may seem slow at this, I have been working with Access for about
a couple of months. With the info. that you have given me. The question I
have is when i create the query, how do I start to input the overdue string
that you have suggested. I looked in the Access book and still tring to read
that. You have given me the light on this and Im learning things here that I
couldn't learn by myself. I just need to understand it to apply it. Thanks
again.

Douglas J Steele said:
Create a query with a computed field that determines whether their claim is
overdue and use the query wherever you would otherwise have used the table.

Since I don't know what your exact table definition is, I can only
approximate what the computed field would be like:

OverdueDays: IIf([Processed] = True, "", IIf(DateDiff("d", [DateReturned],
Date()) > 5, "This person is " & DateDiff("d", [DateReturned], Date()) & "
days over due", ""))

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Hec Jacobson said:
Hello to all that reads this and thank you in advance for any help you guys
can provide. I have just a question, The question is in the database that i
created, I have 2 calendars to track people when they leave for busniess
trips. One calender when they start, and the second calender when they come
back.. They have up to 5 days to complete their travel claims before it
becomes over due. I want to know how I can automatically track after they
come back the 5 days as far as the over due claim. I want to have Access
automatically tell me "this person is 5 days over due.." without having to
creat a YES/NO field and manuallycheck it in. Can you guys tell me how this
can happen? If it cant happen like that, can you guys tell me how I can get
it as close as possible. Thanks for the help.
Click to expand...
Click to expand...
 
D

Douglas J. Steele

Type the expression into a blank cell on the "Field" row in the query grid.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Hec Jacobson said:
Thank you Mr. Steele for your help.

Sorry if I may seem slow at this, I have been working with Access for
about
a couple of months. With the info. that you have given me. The question
I
have is when i create the query, how do I start to input the overdue
string
that you have suggested. I looked in the Access book and still tring to
read
that. You have given me the light on this and Im learning things here
that I
couldn't learn by myself. I just need to understand it to apply it.
Thanks
again.

Douglas J Steele said:
Create a query with a computed field that determines whether their claim
is
overdue and use the query wherever you would otherwise have used the
table.

Since I don't know what your exact table definition is, I can only
approximate what the computed field would be like:

OverdueDays: IIf([Processed] = True, "", IIf(DateDiff("d",
[DateReturned],
Date()) > 5, "This person is " & DateDiff("d", [DateReturned], Date()) &
"
days over due", ""))

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Hec Jacobson said:
Hello to all that reads this and thank you in advance for any help you guys
can provide. I have just a question, The question is in the database that i
created, I have 2 calendars to track people when they leave for
busniess
trips. One calender when they start, and the second calender when they come
back.. They have up to 5 days to complete their travel claims before it
becomes over due. I want to know how I can automatically track after
they
come back the 5 days as far as the over due claim. I want to have
Access
automatically tell me "this person is 5 days over due.." without
having to
creat a YES/NO field and manuallycheck it in. Can you guys tell me how this
can happen? If it cant happen like that, can you guys tell me how I
can get
it as close as possible. Thanks for the help.
Click to expand...
Click to expand...
Click to expand...
 
Top