Solved

HOW DO I SELECT CURRENT DATE IN ACCESS EXPRESSION

Posted on 2014-07-23
2
194 Views
Last Modified: 2014-07-23
91-120: Sum(((IIf([True Date]<=#7/15/2014#-91 And [True Date]>=#7/15/2014#-120,[AMOUNT_BILLED],0))))

I need to change 07/15/14 to what ever the current date is.
0
Comment
Question by:garyrobbins
2 Comments
 
LVL 4

Accepted Solution

by:
Mitchell Milligan earned 500 total points
ID: 40214779
The command: Date() should help you out there.  That returns the current date.
0
 

Author Closing Comment

by:garyrobbins
ID: 40214916
Works Great.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office 2010 is Microsoft's latest edition to their office productivity collection. It "promises to include rich and powerful new ways to deliver your best work". So to start off, I have to say that I'm slightly disappointed... That bei…
To stay competitive, modern businesses must adapt and stay innovative, and this is increasingly only possible by working with outside talent. Managers and executives have understood the power of outsourcing for quite some time, but traditional clien…
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question