Recent content by rvil460

Hello, I created a database that keeps track of truck fuel logs and odometer readings. I am able to add the gallons of fuel used everyday in each truck, however I am having trouble subtracting the odometer readings to find the usage of each truck. I was able to create three queries, one that...

Hello, I have read in multiple locations that Access 2007 does not support user security levels, and I have tried the RunCommand WorkgroupAdministrator Macro MS suggested. I really do not know what that Macro does, or how to use it. Anyway, I was wondering if what I have done is sufficient...

Pbaldy, I figured out what to put in place of your example, and it worked. :) But, now I have come to another problem. If the same piece of equipment moves multiple times in on day, it still shows in all the locations rather than just the most recent. I'm pretty sure it's because the MaxDate...

Lagbolt, Yes, that's the reason for having both, and now that you mention it, it does seem a little redundant. However, if I don't have the pick up field can I still be able to see where the equipment has been? Pbaldy, I think that solution would be suitable, but I am new to Access and to...

Hello, I have a transaction data table where information is put in through a form. The transaction data table includes: Date, Equipment Number, Category, Pick up Location, Pick up Job Number, Current Location, and Current Job Number. This information is typed in daily, and the same equipment...

Hello, I am trying to figure out how to create a report that will show only transactions that have happened. I am tracking equipment and have entered the initial locations, and can create a report showing the current locations. However, that report will show everything that has been entered...

Thank you very much. This will definitely help. :)

The Equipment Category table is to quickly identify what type of equipment it is, rather than a full description. I'm hoping I will be able to create reports that will show, for example, these Loaders with these equipment numbers moved from here to there on this date. People out in the field...

Hi GinaWhipp, That is actually a database I was testing on. I will attach the one I am planning on using. Sorry for not updating that. I really appreciate you looking at it.

I have not created a table for this yet. I wanted to make sure I could update the table without ruining data. This table will be our Job Number table that will have to be updated about every month, but I would like to still be able to report equipment information related to old/deleted job...

spikepl, Thank you for all your help. After a lot of reading, testing, and frustration I think I have something worth using. Now my new question is, will previous information be deleted, or unable to produce reports, if I delete information from a related table?

This is what I'm working on...it may be a deadend. I'm not sure if I'm on the right path or not.

I agree this database will come back to haunt me if I make it as simple as it is right now. Do you think I could create one database that has our whole equipment list, including equipment number, description, and rent/own. Then somehow link that to a drop down list on a form that I can update...

I was recently moved into an equipment tracking/dispatching position. I was asked to develop and implement a tracking system from scratch. Since I have Access 2007 on my computer, I figured I could use that. I have never used Access before, and am new to this. I have messed around with it...