I finally got it to work.
I had issues with date format: I'm using European date format dd.mm.yyyy instead US date format mm/dd/yyyy.
I corrected the code and it's working now:
Thanks for help.
I had issues with date format: I'm using European date format dd.mm.yyyy instead US date format mm/dd/yyyy.
I corrected the code and it's working now:
Code:
LineItemNumber: DCount("[InvoiceNumber]";"sub_InvoiceLineItems";"[InvoiceDate]<= DateValue('" & [InvoiceDate] & "')")Thanks for help.
