HELP for a Query check calendar

[Fede]

Hi to all,

I need to know, how can i have a control about a kind of a day (Work day or Holiday Day)

I have to know if the day in a table "A" was Friday,Saturday or Sunday; if the day i check is like Friday, Saturday or Sunday, i don't want that day will be into my selection table "B".

How can i make a relationship control with my date on table "A" with a calendar ?

I know in Excel is possible but with access i never made this check.

I hope someone can help me!!!

Thank you!!

 

[vbaInet]

How is table A and table B related?

Since you're using a query just apply the criteria under the date field. You will use the Weekday() function to apply your criteria. To understand this, you need to know that Sunday is 1, Monday - 2, .... up to Saturday - 7.

So the criteria can be this:

Weekday([DateField]) <> 1 AND WeekDay([DateField]) <> 6 AND Weekday([DateField]) <> 7

Or you can have:

Weekday([DateField]) Not In ('1', '6', '7')

Not In

 

[Fede]

Hi, thank you for your answer...

The table A and B are related with a Code.

My control is about data of a month, if i use your mode i have to make every month put the number of the days(Friday Saturday and Sunday) before to start my control ? I understand right?

There is not a criteria wich i can use automatically a calendar ?

TY

 

[vbaInet]

My control is about data of a month, if i use your mode i have to make every month put the number of the days(Friday Saturday and Sunday) before to start my control ? I understand right?

If your field only has Months how do you expect to know which weekday it is?

There is not a criteria wich i can use automatically a calendar?

You mean you want to remove Fri, Sat and Sun from the calendar or not allow users choose those days?

 

[Fede]

"If your field only has Months how do you expect to know which weekday it is?"

My field is format date Month/Day/Year;

"You mean you want to remove Fri, Sat and Sun from the calendar or not allow users choose those days?"

I want a selection query wich don't pick up record where the day is Friday...

 

[vbaInet]

I want a selection query wich don't pick up record where the day is Friday...

Exactly what I gave you in my first post (#2). Put that under the criteria row of that date field in your query.

 

[Fede]

Ok now i am trying!!! Thank you very much!!