Append Query Question

Simple problem:
Today is the 9th. I need to be able to append a record for everyday
since the first of this month to yesterday. Now heres the thing, it
won't always be the first of the month (start date) or the 9th (end
date).

The big picture (complex problem dumbed down):
I have a log of all changes that happen in my database and a snapshot
of what my data looks like each day with a date attached to it. There
are different types of changes and are labeled as such in the "Type"
field (A before/after as well, depending on the type). Within a given
change record, there is a Start and End Date. Depending on the type, I
have to either Update/Append/Delete from Start to End Date (which are
past dates) to existing data. Update/Delete I think I have down (takes
my 6 queries just to make the update work :-( but it works ).

Ryan

Use a parameter with your query to pop up a Between "Date1" and "date2"
--
Jeff C
Live Well .. Be Happy In All You Do


"Ryan Clair" wrote:

Simple problem:
Today is the 9th. I need to be able to append a record for everyday
since the first of this month to yesterday. Now heres the thing, it
won't always be the first of the month (start date) or the 9th (end
date).

The big picture (complex problem dumbed down):
I have a log of all changes that happen in my database and a snapshot
of what my data looks like each day with a date attached to it. There
are different types of changes and are labeled as such in the "Type"
field (A before/after as well, depending on the type). Within a given
change record, there is a Start and End Date. Depending on the type, I
have to either Update/Append/Delete from Start to End Date (which are
past dates) to existing data. Update/Delete I think I have down (takes
my 6 queries just to make the update work :-( but it works ).

Ryan