Groups > comp.databases.ms-access > #9086

Matching dates

From	"Phil" <phil@stantonfamily.co.uk>
Newsgroups	comp.databases.ms-access
Subject	Matching dates
Date	2014-02-28 23:20 +0000
Organization	Aioe.org NNTP Server
Message-ID	<ler5kr$1s5$1@speranza.aioe.org> (permalink)

Show all headers | View raw

I am trying to match up dates that accounts are due to be received, with th=
e
dates that they actually are received. Most of the money expected is on a
recurring monthly basis and normally the receipt comes in within about 10
days of the expected date.

So there is a TblAccounts 
 	AccountID as the primary key

TblDueDates
	AccountID	FK
	DueDate
TblTransactions
	AccountID	FK
	TransDate

I have a form with FromMonth & ToMonth, so I want to match up the paid
transactions within those months . By comparing the Month(DueDate) with
Month(TransDate) and Year(DueDate) with Year(TransDate), I get a reasonable=

result, but it goes wrong when say the DueDate =3D 1st March and the TransD=
ate
is 28th February. DateDiff doesn=92t work either as there are numerous near=
ly
matching DueDates and TransDates for each account.

Any ideas how to solve this =93fuzzy=94 logic problem please

Phil

---
This email is free from viruses and malware because avast! Antivirus protec=
tion is active.
http://www.avast.com

Back to comp.databases.ms-access | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Matching dates "Phil" <phil@stantonfamily.co.uk> - 2014-02-28 23:20 +0000
  Re: Matching dates "David Hare-Scott" <secret@nospam.com> - 2014-03-01 10:39 +1100
    Re: Matching dates "Phil" <phil@stantonfamily.co.uk> - 2014-03-01 09:18 +0000
      Re: Matching dates Ulrich Möller <knobbi38@usenet.arcornews.de> - 2014-03-01 12:55 +0100
        Re: Matching dates "Phil" <phil@stantonfamily.co.uk> - 2014-03-01 17:57 +0000
          Re: Matching dates "Phil" <phil@stantonfamily.co.uk> - 2014-03-01 18:00 +0000
            Re: Matching dates Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-03-01 15:23 -0800
              Re: Matching dates "Phil" <phil@stantonfamily.co.uk> - 2014-03-02 09:32 +0000

csiph-web