date expressions 1

[julius1]

Hello, I am putting together a data base and 1 of the queries I am trying to pull is "getting a list of total entries made into a field the day prior" to when I am running the report. For example. There are a total of 30 orders entered on 10-30. I am trying on 10-31 to see how many came in, but I need it to be so that when ever I pull the report on any day it pulls up what was entered the day prior with out me having to go into the query design and modify the date. Can someone help me on this one. I am sure it's simple, but I can not find this type of expression any where that I look.

 

[DanJR]

Hi there,

try using the Date() function:

SELECT Table1.myDate
FROM Table1
WHERE Table1.myDate<Date()

Or, in the desgin view of the query, add the following to the criteria of your date field

<Date()


Hope this helps...
DanJR

 

[julius1]

Dan, thank you very much. This is exactly what I have been looking for!!