Date Query

  • Thread starter Thread starter Paola
  • Start date Start date
P

Paola

I'm trying to perform a query where when the date equals
Monday it will take the hours entered in fill in for
monday column. Any help in contructing the query?

Paola
 
I'm trying to perform a query where when the date equals
Monday it will take the hours entered in fill in for
monday column. Any help in contructing the query?

Paola
Click to expand...

I'm not sure of what you wish to do, but look up the WeekDay()
function in VBA Help.

Assuming the first day of your week is a Sunday:

To filter out all except Monday dates...
Exp:WeekDay([DateField])
as criteria for this column, write:
2

Only records which are a Monday will be returned.

Or .... if you wish to show data in a particular column, only if the
record's date field is a particular day, you could add a new column to
the query.
MondayResults:IIf(WeekDay([DateField])=2,[SomeField],"")
TuesdayResults:IIf(WeekDay([DateField])=3,[SomeField],"")
etc.
 
-----Original Message-----
I'm trying to perform a query where when the date equals
Monday it will take the hours entered in fill in for
monday column. Any help in contructing the query?

Paola
.
Click to expand...
Thank you that worked, apprecite the assistance.

Paola
 
Back
Top