In Ms access Query work as filter in Form

[Salih]

Hi,
I hope you are fine. In this database we have in form text12.
how can we add function in query and form to filter date range
example >=1970-1-1 and <=1990-12-30.

when click button in form run that query

thanks
Salih

 

[GaP42]

Date of Birth is defined as a text type field - If you want this to work DoB needs to be set as a date/time type field in the table.
As it is how will you filter using a text range of >=1970-1-1 and <=1990-12-30
Once you have set up a date/time field for DOB you will need to work with the date portion of the field: review date functions.

 

[arnelgp]

here is the modification.

 

[Salih]

Hi Amelgp.
I real appreciate your help but while running i received windows see plz the attached file

thx
Salih

 

[MajP]

 

[arnelgp]

as shown in post #5, right click the downloaded db and goto its Property, then check unblock.

 

[Salih]

as shown in post #5, right click the downloaded db and goto its Property, then check unblock.

Hi

arnelgp,​

Thanks for you answering my appearing question, I forget, how can i show all dates,
without given limited range, like also add (All records) as we did for other filter
another question since i m new in MS access
i try this code ,when i leave blank it did not work
BETWEEN IIf(IsNull([StartDate]),[StartDate]) AND IIf(IsNull([EndDate]), [EndDate]))

Thanks
Salih