Docmd.openform (date) and (text)

[sovereign]

Afternoon,

I am trying to open a form with multiple conditions, they work perfectly on there own but when i combine i get a type mismatch error.

DoCmd.OpenForm "frmdashboardall", , , "[A_EventsCreatedOn]<= date()-7"

and

DoCmd.OpenForm "frmdashboardall", , , "[Pstatus] = 'New Claim'"

But obviously i need the code combined. I tried adding AND in the middle of the two criteria but it didn't work.

Any help??

[CJ_London]

it should do

"[A_EventsCreatedOn]<= date()-7 AND [Pstatus] = 'New Claim'"

[sovereign]

ah! so simple I was wrapping each one on " " so think that's where I was going wrong! Thank you!

Quick one also, is it possible to use "last()" or "Max()" in the criteria?

regards

[CJ_London]

Quick one also, is it possible to use "last()" or "Max()" in the criteria?

not in the accepted sense as used in a group by query, but you can use such a group by query in your criteria

e.g. "[A_EventsCreatedOn]=(SELECT Max([A_EventsCreatedOn]) FROM myTable as T)"

or this will return the records for the top 10 dates "[A_EventsCreatedOn] IN (SELECT Top 10 [A_EventsCreatedOn] FROM myTable as T ORDER BY [A_EventsCreatedOn] Desc)"


or use one of the domain functions

e.g. "[A_EventsCreatedOn]=DMax('[A_EventsCreatedOn]','myTable')"