Adding in data based on dates

[Schwimms]

If I have a historical file in access, and then I recieve a file every week
that has the past 17 days. Is there a way to get access to merge JUST the
past days that are not included in the history.

So you have a report that is from 2/7/05 through 2/7/08. I recieve a report
for 1/28/08 through 2/14/08. I want to just add on the 2/8/08 through 2/14/08
data. Is that possible?

How can I do this?

 

[Al Campagna]

Schwimms,
You should be able to determine the latest date in your History table.
DMax("[HistoryDate]", "tblHistory")
Then filter your import with a Date criteria of ...
ImportDate > DMax("[HistoryDate]", "tblHistory")
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Schwimms]

That looks like a macro? I am not proficient in access, can you explain the
steps?

Schwimms,
You should be able to determine the latest date in your History table.
DMax("[HistoryDate]", "tblHistory")
Then filter your import with a Date criteria of ...
ImportDate > DMax("[HistoryDate]", "tblHistory")
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

If I have a historical file in access, and then I recieve a file every
week
that has the past 17 days. Is there a way to get access to merge JUST the
past days that are not included in the history.

So you have a report that is from 2/7/05 through 2/7/08. I recieve a
report
for 1/28/08 through 2/14/08. I want to just add on the 2/8/08 through
2/14/08
data. Is that possible?

How can I do this?

 

[John W. Vinson]

If I have a historical file in access, and then I recieve a file every week
that has the past 17 days. Is there a way to get access to merge JUST the
past days that are not included in the history.

So you have a report that is from 2/7/05 through 2/7/08. I recieve a report
for 1/28/08 through 2/14/08. I want to just add on the 2/8/08 through 2/14/08
data. Is that possible?

How can I do this?

In what form do you get this file, and how do you merge it? A Query is going
to be your best bet, but to give a detailed step by step I'll need to know how
you're getting the data (and tablenames and the name of the date field if
possible).

 

[Al Campagna]

Schwimms,
I would assume that your importing the new data into a temporary Access
table (ex. tblImport), and then running an Append query to take certain
records out of that table and Append them to your "working" table (ex.
tblMyTable).
The...

DMax("[HistoryDate]", "tblHistory")

would be the criteria that you would apply against the Date field in
tblImport, to only append records with a date greater than that value into
tblMyTable.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

That looks like a macro? I am not proficient in access, can you explain
the
steps?

Schwimms,
You should be able to determine the latest date in your History
table.
DMax("[HistoryDate]", "tblHistory")
Then filter your import with a Date criteria of ...
ImportDate > DMax("[HistoryDate]", "tblHistory")
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

If I have a historical file in access, and then I recieve a file every
week
that has the past 17 days. Is there a way to get access to merge JUST
the
past days that are not included in the history.

So you have a report that is from 2/7/05 through 2/7/08. I recieve a
report
for 1/28/08 through 2/14/08. I want to just add on the 2/8/08 through
2/14/08
data. Is that possible?

How can I do this?