like [date]?

[fifik87]

i need help. i have a parameter query. there i have parameter like [Mechanic], and like [no of machine]. because i want to get data by one of theese parameter or both. it works fine, where i as input enter * , it select data by the other parameter. and i need the same with date field, but this doesnt work. do someone know how can i do that?
thanks

 

[ColinEssex]

If your date field is called "Date", you may need to rename it - the word "Date" is a reserved word in Access and can lead to internal confusion.

Then in the (now renamed) date field criteria put this

 [Enter a date]

Col

 

[fifik87]

thanks

thank you, it help me. now it works.

 

[fifik87]

can you also help me with this same thing. but now i need to use between .. and.. with like [date], but i dont know to do this.
thanks

 

[ColinEssex]

 Between [Enter first date] and [Enter second date]

Col

 

[fifik87]

yes, but i need to use like, when i use like , i dont get anything

 

[ColinEssex]

Why do you need "like"?


Col

 

[fifik87]

because i need to filter data by one of parameter (mechanic, no. of machine, date interval) or by combination of two or three