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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DTTODGG - 17 Jul 2006 21:29 GMT

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!

Reply to this Message

John Vinson - 18 Jul 2006 06:06 GMT

>Hello-
>
[quoted text clipped - 4 lines]
>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"
[quoted text clipped - 9 lines]
>in Access? or Excel? In the end, I would like a report that just shows the
>rows that where changed today.

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]

Reply to this Message