Combining expressions

[Bill Davis]

I have a cross tab query and need to have it pull only
2004 date this is the expression
Format([research_completed],"mmm/yy")
I tried to this:
Format([research_completed],"mmm/yy") And Year
([research_completed])=Year(Now())
but it did not work.. Help Please..
Thanks..

 

[fredg]

I have a cross tab query and need to have it pull only
2004 date this is the expression
Format([research_completed],"mmm/yy")
I tried to this:
Format([research_completed],"mmm/yy") And Year
([research_completed])=Year(Now())
but it did not work.. Help Please..
Thanks..

I'm confused.

Do you want for just the current month? Or for the current year?

Assuming [Research_Completed] is a Date datatype field....
Current month only:

Where Format([Research_Completed],"mm/yyyy") =
Format(Date(),"mm/yyyy")

for the Current Year:
Where Year([Research_Completed]) = Year(Date())

 

[Bill]

Fred,
I am using a Cross Tab wizard to create a query that is
by month and it is pulling 2003 and 2004 records. What I
need is only the data for 2004. This is my first time
using a Cross Tab query so I am not sure if this is
possible.
Thanks

-----Original Message-----

I have a cross tab query and need to have it pull only
2004 date this is the expression
Format([research_completed],"mmm/yy")
I tried to this:
Format([research_completed],"mmm/yy") And Year
([research_completed])=Year(Now())
but it did not work.. Help Please..
Thanks..

I'm confused.

Do you want for just the current month? Or for the current year?

Assuming [Research_Completed] is a Date datatype field....
Current month only:

Where Format([Research_Completed],"mm/yyyy") =
Format(Date(),"mm/yyyy")

for the Current Year:
Where Year([Research_Completed]) = Year(Date())

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

 

[Guest]

Fred,
I figured it out.
Thanks Bill.

-----Original Message-----

I have a cross tab query and need to have it pull only
2004 date this is the expression
Format([research_completed],"mmm/yy")
I tried to this:
Format([research_completed],"mmm/yy") And Year
([research_completed])=Year(Now())
but it did not work.. Help Please..
Thanks..

I'm confused.

Do you want for just the current month? Or for the current year?

Assuming [Research_Completed] is a Date datatype field....
Current month only:

Where Format([Research_Completed],"mm/yyyy") =
Format(Date(),"mm/yyyy")

for the Current Year:
Where Year([Research_Completed]) = Year(Date())

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.