format date

[Zonie32]

Hello,

I have this expression in my query
Coverage Period: Format(Now()+16,"mmmm"", ""yyyy")

In the criteria section I want to be able to choose the month I need the report for, so I thought I would put in this section the following:

[Enter Month]

However, that does not work. How would I be able to run this query and choose only the month I need? Would I have to change the Format piece of this expression to exclude NOW(). I'm lost. Any help is appreciated. thank you.

 

[Remou]

What is the name of the date field? You need to end up with something like:

[tt]<...> WHERE Month(DateField)= [Enter Month] And Year(DateField)=Year(Date())[/tt]

 

[Zonie32]

Hi there,

See that is my problem. There is no "date" field, which I just found out. This is not a database I created, I am just trying to help someone else with theirs that was created years ago by a company out of business now.

So after looking at the query more, I realized there was not a date field to reference, so I'm not sure how they can go back and type in "March" to get the March people that should have been billed. I think it's a lost cause at this point! Thanks for responding. Have a great day.

 

[SkipVought]

Hi,

Maybe, yech, they have a separate table for each period? bracgh!!!!!

Skip,

_[red][/red]