Append to Query if date is null

[wesley.allen]

Hello. I am trying to run a query that will post information to a
table when the database opens. I want it to post the balance from a
query with today's date.

I want to know if there is a way to post the informtion only if it is
not already in the databse for that day.

Thanks.

 

[Allen Browne]

You could use a subquery in the WHERE clause to limit your query's result to
those that don't have an entry for the date.

If subqueries are new, here's a starting point:
http://allenbrowne.com/subquery-01.html#NotThere