Calculating Late Date in Access

[whiteboy]

What's up Everyone?

I really need some help. I've been pulling the hair out of my head
trying to research how to calculate a late date. Here is what I'm
trying to do:
DATE VOUCHER SUBMITTED: 1 MAY 06
VOUCHER LATE?: YES
If the voucher is 5 days past the "DATE VOUCHER SUBMITTED" date, I'd
like to have it autmatically update another field named "VOUCHER LATE"
either with a yes/no answer. Is there a way to make this happen? If
there is, I should be able to query this info and create a report
right? Thanks in advance for your help.

[PC Datasheet]

Put the following expression in a blank field in your query:
LateDate:DateDi ff("d",[Date Voucher Submitted],Date())
Set the criteria to:

=5
The query will return all vouchers that are 5 or more days late.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
re******@pcdata sheet.com

"whiteboy" <be************ ****@langley.af .mil> wrote in message
news:11******** **************@ d71g2000cwd.goo glegroups.com.. . What's up Everyone?

I really need some help. I've been pulling the hair out of my head
trying to research how to calculate a late date. Here is what I'm
trying to do:
DATE VOUCHER SUBMITTED: 1 MAY 06
VOUCHER LATE?: YES
If the voucher is 5 days past the "DATE VOUCHER SUBMITTED" date, I'd
like to have it autmatically update another field named "VOUCHER LATE"
either with a yes/no answer. Is there a way to make this happen? If
there is, I should be able to query this info and create a report
right? Thanks in advance for your help.

[StopThisAdvertising]

"PC Datasheet" <No****@Spam.Co m> schreef in bericht news:KO******** *******@newsrea d1.news.pas.ear thlink.net...
--

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1175 users have come to me from the newsgroups requesting help '1175 users ????
re******@pcdata sheet.com

--
To Steve:
You have been away only for a little while
Since no-one wants your advertising/job hunting here you are allowed to stay away longer!

Over 825 !! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:
Your question is also answered in the group ms.public.acces s Please don't multipost.
About Steve:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.
==> And he is also known here as a shameless liar with *no ethics at all.*

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R

[Bob Quintal]

"whiteboy" <be************ ****@langley.af .mil> wrote in
news:11******** **************@ d71g2000cwd.goo glegroups.com:

What's up Everyone?

I really need some help. I've been pulling the hair out of my
head trying to research how to calculate a late date. Here is
what I'm trying to do:
DATE VOUCHER SUBMITTED: 1 MAY 06
VOUCHER LATE?: YES
If the voucher is 5 days past the "DATE VOUCHER SUBMITTED"
date, I'd like to have it autmatically update another field
named "VOUCHER LATE" either with a yes/no answer. Is there a
way to make this happen? If there is, I should be able to
query this info and create a report right? Thanks in advance
for your help.

As usual PC Datasheet's answer is incomplete and does not
satisfy the requirements.

Instead of what he wrote,
LateDate:DateDi ff("d",[Date Voucher Submitted],Date())
you need to embed the datediff function into an iif statement.

Create an update query. bring down the [Voucher Late] field. .

put this in the update to row.

iif(DateDiff("d ",[Date Voucher Submitted],Date()) >=5, -1,0)

(watch out for linewrap.)

--
Bob Quintal

PA is y I've altered my email address.

[PC Datasheet]

Bob,

I thought previously you indicated you were going to be polite. Is that not
part of your personality?

Steve
"Bob Quintal" <rq******@sympa tico.ca> wrote in message
news:Xn******** **************@ 207.35.177.135. ..

"whiteboy" <be************ ****@langley.af .mil> wrote in
news:11******** **************@ d71g2000cwd.goo glegroups.com:

What's up Everyone?

I really need some help. I've been pulling the hair out of my
head trying to research how to calculate a late date. Here is
what I'm trying to do:
DATE VOUCHER SUBMITTED: 1 MAY 06
VOUCHER LATE?: YES
If the voucher is 5 days past the "DATE VOUCHER SUBMITTED"
date, I'd like to have it autmatically update another field
named "VOUCHER LATE" either with a yes/no answer. Is there a
way to make this happen? If there is, I should be able to
query this info and create a report right? Thanks in advance
for your help.

As usual PC Datasheet's answer is incomplete and does not
satisfy the requirements.

Instead of what he wrote,
LateDate:DateDi ff("d",[Date Voucher Submitted],Date())
you need to embed the datediff function into an iif statement.

Create an update query. bring down the [Voucher Late] field. .

put this in the update to row.

iif(DateDiff("d ",[Date Voucher Submitted],Date()) >=5, -1,0)

(watch out for linewrap.)

--
Bob Quintal

PA is y I've altered my email address.

[Tim Marshall]

PC Datasheet wrote:

Put the following expression in a blank field in your query:
LateDate:DateDi ff("d",[Date Voucher Submitted],Date())
Set the criteria to:

=5

The query will return all vouchers that are 5 or more days late.

The only thing I'd add to this is that Benjamin does NOT want to update
a field stored in a table. Although he didn't exactly say so, this is
what he imtimated when he asked to have 'it autmatically update another
field named "VOUCHER LATE" either with a yes/no answer'.

Steve's solution to use a query is the more appropriate way to do things.

The general rule of thumb is to *never* store a value that can be easily
calculated.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Tim Marshall]

Tim Marshall wrote:

PC Datasheet wrote:

Put the following expression in a blank field in your query:
LateDate:DateDi ff("d",[Date Voucher Submitted],Date())
Set the criteria to:

=5

Oh, I just realized - the criteria should be >=5. With just =5, the
only ones that will show up are ones that are 5 days late, 6 or more
won't show up! 8)

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[StopThisAdvertising]

"Tim Marshall" <TI****@PurpleP andaChasers.Moe rtherium> schreef in bericht news:e4******** **@coranto.ucs. mun.ca...

Tim Marshall wrote:

PC Datasheet wrote:

Put the following expression in a blank field in your query:
LateDate:DateDi ff("d",[Date Voucher Submitted],Date())
Set the criteria to:

=5

Oh, I just realized - the criteria should be >=5. With just =5, the
only ones that will show up are ones that are 5 days late, 6 or more
won't show up! 8)

Tim,
Steve did say >=5 in his reply ...
However he did not meet the OP's requirements (OP wanted a yes/no output) as Bob pointed out.
But what makes Steve's answer *real* messy is the sigline!

Arno R

[John Marshall, MVP]

"PC Datasheet" <No****@Spam.Co m> wrote in message
news:3L******** ********@newsre ad1.news.pas.ea rthlink.net...

Bob,

I thought previously you indicated you were going to be polite. Is that
not part of your personality?

steve

From the local expert on politeness.

John... Visio MVP

[Tim Marshall]

StopThisAdverti sing wrote:

Tim,
Steve did say >=5 in his reply ...

Ah, I see. Netscrape 7.2 replaces standard > signs at the beginning of
a line with some bizarre character - I haven't figured out how to make
it not do that. Duh! 8)

My point was, despite the sig, which I agree doesn't belong here, I
think Steve correctly directed the OP to a query rather than inserting a
value into a table. OTOH, now that I think about it, such storage
could be valid if one is making records of when payments are due and
records of late/on time payments.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me