Check DUE DATE in Mirosoft access.???????????

[JasonLiew]

HI to all expert out there,

I have a problem in creating a functon to check for Date(A) with current date.... I want it to auto response me 2 weeks before Date(A). Can it be done? I need an example.

regards.
Jason

 

[mswilson16]

From what I understand from your post this will do the job, if not then can you go into more detail with your post.

Why not use the dLookup or dCount function and then in the criteria put in something like this:

Dcount("[DATE(A)]","table","[Date(A)] between #" & now() & "# AND #" now()+14 & "#&quot

This will tell you when the [DATE(A)] is between Now() (Todays date) and the next 14 days.

I find that Dcount is better than Dlookup as it can manage null values better.

 

[JasonLiew]

Hi mswilson16,

I think theres a syntax error.
It show a warning:

Compile Error:
Expected: list seperator or ]

Jason.