Query Criteria based on an input date

[shaz123]

Yes my original code was:

[Forms]![Works Order Import Date Selection]![Enter From Date] And [Forms]![Works Order Import Date Selection]![ Enter End Date]

 

[Brianwarnock]

Yes my original code was:

[Forms]![Works Order Import Date Selection]![Enter From Date] And [Forms]![Works Order Import Date Selection]![ Enter End Date]

Is the missing Between a typo? in you post or criteria?

Brian


Also you have an extra space before Enter End Date again where is the typo in the post or the criteria?

 

[shaz123]

It works thankuuuuuuu

 

[Brianwarnock]

Our own syntax errors are the hardest to spot

Glad its working

Cheers

Brian

 

[shaz123]

It works thankuuuuuu, i was missing the Between