Criteria the day (Today)

[editolis]

Hi all.

I need your help with a simple qry.

I Have 500 files ascending by the day.

Let say for example today is Wednesday then I want the qry to open the files connecting to Wednesday. That’s all.

Thank you in advance.

 

[WayPay]

Is the weekday in the filename, or the date?

 

[editolis]

Is the weekday in the filename, or the date?

I am talking about all days. From Monday to Sunday,

I want the qry to recognize the today day and to open the qry by these criteria.

 

[Brianwarnock]

I presume that you want all of the rows from your table where the date is a given day
Format(yourdatefield,"dddd") will give the day and then enter the day you want in the criteria.

Read up on the Format function.

Brian

 

[Brianwarnock]

If you always want todays day , having reread your 1st post, then apply the Format to Date() in the criteria.

Brian

 

[editolis]

If you always want todays day , having reread your 1st post, then apply the Format to Date() in the criteria.

Brian

Thank you Brian