I don't even know where to ask - same post in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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).
ok...

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.
Click to expand...

I'd do it in Access, using a query. You can join the table to itself
by SerialNumber; use Date() as a criterion on the first instance of
Column B, Date() - 1 as a criterion on the second, to get today's and
yesterday's dates (you don't skip holidays or weekends?); and put a
criterion of

<> Tablename.ColumnB

on Tablename_1.ColumnB (assuming that you've taken the default alias
for the table name).

This query can then be turned into an Update query, or you can base
your Excel export on it.

John W. Vinson[MVP]
 
Back
Top