changing #error to blank in a query

[KenshiroUK]

Running a query based on todays date

Hi, is it possible to run a query based on today. Basically I have a created a query that looks up customer orders and places them in a table to exported into a text file. However I do not wish for duplicate orders, for instance if I wanted to run my query tomorrow I do not with for yesterdays orders to be placed with in that table, I would want the day I ran it, or if I missed 2 days it would return two days that I missed.

Is this possible in anyway?

 

[Trevor G]

Look to use a date parameter option or between dates as the parameter.

 

[MSAccessRookie]

You might also want to consider using the Domain Function DMax() to find the most recent (highest) date in the Target Table, and then selecting any records in the Source Table that have a more current Date. The one advantage that this provides is that you will not need to know how many days are missed, since Access will figure that out for you.