Recent content by MrLee

The data only includes new data...ie. transactions that are new. However the data for the last 45 days are stored in the same Access system.

I can update the odometer readings for each vehicle when there is only one transaction for a particular vehicle. But what about if there are two, three, four or more transactions for a particular vehicle? Is it even possible to run a query until there are no more transactions for a particular...

Hello, does anyone know any good sites to learn VBA and connecting with databases? I am not familiar with Visual Basic. Thanks, MrLee

Below is an example of three transactions for three different vehicles. I had to break it up into four seperate lines, because of the limitations of this window. So when these transactions are brought in, they are put into a final table. In order to get the current odometer reading I can run...

the problem I am trying to get around is to be able to grab the records from a table which holds data regarding fuel transactions. The data I am concerned about is the odometer readings...the transaction data comes into the database and updates the current odometer reading. The only problem is...

I thought about using an update query, but in my database there are vehicles listed. Among other data that is listed are the odometer readings for each vehicle. When the macros and queries are run, new transactions for some of the vehicles are brought in. As I thought, an update query would...

I am relatively new to this and was wondering how to connect my form to a table? Thanks, MrLee

Alirght, what I really need to do is to put a list of transactions through a loop to calculate the difference...then update the column back in the database. Does this sound possible? Mike

Hello, is there a way to read the data in an access table, perform calculations on a field based on other fields then re-enter the field into the database? Thanks, MrLee

Hello, is there a way to read the data in an access table, perform calculations on a field based on other fields then re-enter the field into the database? Thanks, MrLee

One other thing...with all that has been said, would it be simpler to modify the data after it is brought into the database? Thanks, MrLee

Hello All, I saw your website and was wondering if you could possibly provide me with some advice. Currently I have an MS Access based system/database which is run via a macro. This macro basically uploads several text files into the database and loads them into tables. This text file is...