Recent content by born2gamble

I assume I would need to create one table per each truck. ID....Date....Truck....State....Odometer.....Miles Driven 1.....Date....TruckA...UT.......500..........row id2 -id1 2.....Date....TruckA...AZ.......1000.........row id3- id2 3.....Date....TruckA...NV.......1,700........etc Is it...

The 1st line on the Main section= When the driver turns on the truck, wherever he is at, he will note down the location he is currently at and odometer reading. He will finish his run and his last location (where he drops the truck off and goes home) will be noted on the Unloading Section...

When there is a part load delivered to 2 or more customers? Its still one trip sheet. For example. A customer may call, and say, ok i need you to pick this up and deliver part of it to LocationA and part of it to LocationB. So on the trip sheet, the driver will place that information on the...

Yes to the first question, but also filtered by each truck. So the query would pull Truck1 CA = 1,500 miles driven Truck 1 NV = 800 miles driven Truck2 CA = 1400 miles driven etc. Its not visible on the pdf, but i will be inputting the Truck number in access. (TripSheetTractor) Each Sheet...

It is not necessary for IFTA purposes. They just want the total miles driven in each state per each truck ( TripSheetTractor) every 3 months.

The Start of his journey will always be the 1st line of the Main Section which in this case is (A) 19637 on the odometer The end of his journey will always be the last line of the Unloading Section, in this case its (H) 20365 on the odometer

Your right. Well for IFTA purposes, I need to know how many total miles were driven in each state. Yes, the driver will note down his mileage while crossing a state line and note that at the top where you see the majority of the odometer entries.They will also note the mileage when...

That is correct, the driver will record the mileage when he reaches a different state. Please disregard the Loading section and down for now. I will be able to figure that out based on how to attack the top portion. I named the top portion TripSheetMainOdometer1 2 3 4 etc and...

Hi..having trouble with how to attack this. Attached a pdf (showing how the form will look) and my access table is attached. What I need at the end of the day is for me to be able to just look at how much total miles were driven in each state. This pdf represents 1 trip, and there will be many...

Hmm thanks for the link, found that helpful for something I was trying to accomplish

I have a Navigation Form. On one tab, I have a multiple Items Form. I made a openform macro, that when i click on an individual recordID (on click-embedded macro), it opens up another form, with that recordID full details. However, it keeps opening up that form in a different window. Is it...

http://www.youtube.com/watch?feature=endscreen&NR=1&v=pMiJHhjzC8Y

Attached is an updated database structure or a picture of the relationships. I read the database normalization wiki, but am still new to this. Again, the reason for my layout is because one of my clients can have many different pickup address locations. Thanks

I am new to this, and am having some issues with this. I use access 2010. I think I have a similar situation. I have ComboBox1, ComboBox2 ComboBox2 is filtered results based on ComboBox1 Selection. (cascading) I then have a listbox, that based on ComboBox1 and ComboBox2 selections, displays...

argh..that bad huh....I will read some more and re-structure it so that its easier to understand. As is its... tblpickup is just an address table ID-(PK) Name Address Address2 tblMain is the order form where most of the info will be stored. ID (PK) Driver Phone PickupID - (FK)will relate...