dodgeking3171
New Member
- Joined
- Feb 6, 2014
- Messages
- 39
Hey Guys,
So heres what im trying to do. Im using Excel to go through a access database to figure out What parts we sold yesterday, how many, and who the supplier is.
Everything worked great. There is some basic excel formulas to find the supplier and to weed out all of the special order stuff that we do not stock
I wanted to make this update automatically. Before i was just going through and copy pasting the records from yesterday and letting excel go through and make my pivot table.
I thought that i could link a access database, then sort by date to only show yesterday, and away it would go. Problem is excel seems to freeze up when i try to do this. I can fix the freezing problem by getting rid of the formula to find the supplier so that it will sort out the date, But the supplier is a huge item needed to make this function the way i want it too
The database is 440,000 records long. So its huge.
My question is can i only pull data from the last day or week from the access database? Im not sure how to supply my spreed sheet as im sure that would be helpfull for anyone trying to lend a hand.
thanks in advanced
So heres what im trying to do. Im using Excel to go through a access database to figure out What parts we sold yesterday, how many, and who the supplier is.
Everything worked great. There is some basic excel formulas to find the supplier and to weed out all of the special order stuff that we do not stock
I wanted to make this update automatically. Before i was just going through and copy pasting the records from yesterday and letting excel go through and make my pivot table.
I thought that i could link a access database, then sort by date to only show yesterday, and away it would go. Problem is excel seems to freeze up when i try to do this. I can fix the freezing problem by getting rid of the formula to find the supplier so that it will sort out the date, But the supplier is a huge item needed to make this function the way i want it too
The database is 440,000 records long. So its huge.
My question is can i only pull data from the last day or week from the access database? Im not sure how to supply my spreed sheet as im sure that would be helpfull for anyone trying to lend a hand.
thanks in advanced