Re: Date Parameters
- From: John Spencer <spencer@xxxxxxxxx>
- Date: Mon, 23 Jun 2008 15:14:25 -0400
Well, to fix the immediate problem you could probably use something like the following.
=DCount("[Call In Date]","Maintenance Info","([Completed By]='Jane Doe' Or
[Completed By-Second]='Jane Doe') And ([Call In Date] >=DateSerial(Year(Date()),1,1) And
[Call In Date]< DateSerial(Year(Date()),2,1))")
HOWEVER, I would venture to guess that there would be a much simpler way to fix this problem. In order to figure that out we would need to know more about the data structure and more about how these reports vary.
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
jlo wrote:
I have inherited a database that has reports for each month of the year. Inside the report are well over 50 fields that have expressions. In each expression, there is a date referenced. By the beginning of the next year, I have to change the current year to the new year." This is so tedious. Isn't there a way to do this better? Here is a sample of one expression. At the end of the year, I will have to go into 200 of these fields and change the year date to the new year..
Fields: Call In Date (date w/time); Completed By; Completed By-Second
=DCount("[Call In Date]","Maintenance Info","([Completed By]=Jane Doe' Or [Completed By-Second]='Jane Doe') And ([Call In Date] >=#01/01/2008# And [Call In Date]< #02/01/2008#)")
Any suggestions?
- Follow-Ups:
- Re: Date Parameters
- From: jlo
- Re: Date Parameters
- Prev by Date: Re: font error
- Next by Date: send out a report as an email on snapshop format
- Previous by thread: Printing Labels with Dymo printers, user chooses which printer they want.
- Next by thread: Re: Date Parameters
- Index(es):
Relevant Pages
|
