Have not a clue how to do this
 

Hello-

I don't even know if I'm in the right place to ask the question. Please help
if you can.

Everyday, I open an Access database that reads from some other bigger
database via ODBC. I have a query that pulls a few columns of data into
Access (which I just update and export into Excel).

But, I need to compare one of the columns of data with the previous days
data. If it is not the same, move yesterdays data (which is in the "TODAY"
column) to "PREVIOUS" column and put the new data in "TODAY".

Column A = Serial Number
Column B = TODAY's date
Column C = TODAY's (IP Address)
Column D = PREVIOUS date
Column C = PREVIOUS (IP Address)

I have NO idea where the best place for this action is. Is it better to do
in Access? or Excel? In the end, I would like a report that just shows the
rows that where changed today.

I'm certain I will probably have to expand on this, but this should get me
started.

Thank you so much!

Have not a clue how to do this
 

IMO this task is best suited to Access (database). Excel is designed
(primarialy) to manipulate numerical data. You are not trying to manipulate
numerical data. You are trying to relate data from two different days to see
if they match... That is best done in a database.
--
HTH...

Jim Thomlinson


"DTTODGG" wrote:

Hello-

I don't even know if I'm in the right place to ask the question. Please help
if you can.

Everyday, I open an Access database that reads from some other bigger
database via ODBC. I have a query that pulls a few columns of data into
Access (which I just update and export into Excel).

But, I need to compare one of the columns of data with the previous days
data. If it is not the same, move yesterdays data (which is in the "TODAY"
column) to "PREVIOUS" column and put the new data in "TODAY".

Column A = Serial Number
Column B = TODAY's date
Column C = TODAY's (IP Address)
Column D = PREVIOUS date
Column C = PREVIOUS (IP Address)

I have NO idea where the best place for this action is. Is it better to do
in Access? or Excel? In the end, I would like a report that just shows the
rows that where changed today.

I'm certain I will probably have to expand on this, but this should get me
started.

Thank you so much!