filter in query (1 Viewer)

[mana]

hello

i wrote the below filter in a query in ms access but it doesn't work
can you help me please?
thank you


Between Format([Forms]![frm_Charts]![Text109];"yyyy-mm-dd") And Format([Forms]![frm_Charts]![Text111];"yyyy-mm-dd")

 

[jdraw]

Format returns a string. You are using/coding to work with Dates.
Access uses American date format MM/DD/YYYY

You could research CDate function
see http://www.techonthenet.com/access/functions/datatype/cdate.php