Recent content by virus

Got it with this: DCount("*", "LNINST", "[ACC] ='" & [LNACC].[ACC] & "' AND [DUEDATE] < 42369") ... removing the ' ' of 42369.. thank you so much arnelgp...

Result is #Error

Message box appear... "The specified field '[ACC]' could refer to more than one table listed in the FROM clause of your SQL statement."

it didn't work as well... attach is the screenshot of my query..

CJ_LONDON, it didn't work...

Hi there... I have a problem of DCOUNT, this is my query expression: DCount("[DUEDATE]", "LNINST", "[DUEDATE] < 42369") Note: DUEDATE field was converted into numeric character ... where 42369 is equivalent to 12/31/2015.. In DUEDATE field...

Hi there... I have also a problem of DCOUNT, this is my query expression: DCount("[DUEDATE]", "LNINST", "[DUEDATE] < 42369") Note: DUEDATE field was converted into numeric character ... where 42369 is equivalent to 12/31/2015.. In DUEDATE field, its include the next maturing date where...

Hi everyone... im newbie here, and im newbie also to access program... i love doing access program, it makes my mind terrible! hehehehehehe... Chao! to All!