Hi,
I have a table with a date field
I want a query that displays all records from last monday till now
So I wrote:
>Date - Weekday(Date; vbMonday) + 1
this returns an errormassage saying:
"The expression you entered has an invalid .(dot) or ! operator or invalid paramaters"
Cursor stood on the first bracked (
So I changed it to
>Date()-Weekday(Date();vbMonday)+1
This returns an errormessage saying:
Data type mismatch in criteria expression
Access changed the syntax above into
>Date()-Weekday(Date();"vbMonday")+1
placing vbMonday between "
What is wrong
Thanks
:banghead:
I have a table with a date field
I want a query that displays all records from last monday till now
So I wrote:
>Date - Weekday(Date; vbMonday) + 1
this returns an errormassage saying:
"The expression you entered has an invalid .(dot) or ! operator or invalid paramaters"
Cursor stood on the first bracked (
So I changed it to
>Date()-Weekday(Date();vbMonday)+1
This returns an errormessage saying:
Data type mismatch in criteria expression
Access changed the syntax above into
>Date()-Weekday(Date();"vbMonday")+1
placing vbMonday between "
What is wrong
Thanks
:banghead: