<div>
IF ImportDate is purely a date field (no time component) then<br />
<br />
WHERE (((SalesHistory.ImportDate<wbr />)=Date() -1))<br />
<br />
Otherwise, you will need something like:<br />
<br />
WHERE (SalesHistory.ImportDate&gt;=<wbr />Date() -1)<br />
AND (SalesHistory.ImportDate &lt;&nbsp;Date())
</div>


IF ImportDate is purely a date field (no time component) then

WHERE (((SalesHistory.ImportDate)=Date() -1))

Otherwise, you will need something like:

WHERE (SalesHistory.ImportDate>=Date() -1)
AND (SalesHistory.ImportDate < Date())

<div>
In T_SQL you would use: <br />
<br />
DATEADD(day,-1,GETDATE())<br />
<br />
For JET (Access):<br />
<br />
Dateadd(&quot;d&quot;,-1,Date())
</div>


In T_SQL you would use:

DATEADD(day,-1,GETDATE())

For JET (Access):

Dateadd("d",-1,Date())

<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I am looking for help with an access query, <br />
I am looking for the date parameter to be the system date -1 day<br />
<br />
My current query is <br />
<br />
SELECT Products.ItemNumber, Products.ItemName, Sum(SalesHistory.Revenue) AS SumOfRevenue, Sum(SalesHistory.NumberSol<wbr />d) AS SumOfNumberSold<br />
FROM Products INNER JOIN SalesHistory ON Products.ItemNumber = SalesHistory.ItemNumber<br />
WHERE (((SalesHistory.ImportDate<wbr />)=Date()))<wbr /><br />
GROUP BY Products.ItemNumber, Products.ItemName<br />
ORDER BY Sum(SalesHistory.NumberSol<wbr />d) DESC;
</div>
</div>


Hi, 

I am looking for help with an access query, 
I am looking for the date parameter to be the system date -1 day

My current query is 

SELECT Products.ItemNumber, Products.ItemName, Sum(SalesHistory.Revenue) AS SumOfRevenue, Sum(SalesHistory.NumberSold) AS SumOfNumberSold
FROM Products INNER JOIN SalesHistory ON Products.ItemNumber = SalesHistory.ItemNumber
WHERE (((SalesHistory.ImportDate)=Date()))
GROUP BY Products.ItemNumber, Products.ItemName
ORDER BY Sum(SalesHistory.NumberSold) DESC;

Microsoft Access Query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.