Date 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

 

[fredg]

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 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.

 

[Guest]

-----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
.

Thank you that worked, apprecite the assistance.

Paola