Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have no clue about how to use vba | Excel Discussion (Misc queries) | |||
Not a clue of which function to use! | Excel Discussion (Misc queries) | |||
No Clue... | Excel Programming | |||
I have not got a clue | Excel Discussion (Misc queries) | |||
any clue? | Excel Programming |