Recent content by KRISTIRG

I said that's what the pounds were set to. Pounds are a weight, they can't be set to currency.

Huh. Well besides adding the tblCustomerStop with it's 2 fields of CustomerID and StopID I'm not sure at all what else I need to do. Honestly, I'm not even sure how to utilize that table since everything is set up the way I was doing it. But I'm trying to populate the new table. Right now I'm...

I have an additional table setup now to just combine customer and stop number. So if anyone has any ideas on my original question of how to set up the data entry I would love to hear them! Nothing I've tried has worked. Using tb;CustomerStop as the go between as a subform, I set it to default as...

The way the queries are set up now is to match the LoadID, StopNumber and CustomerID from the tblStopFeesDetail and tblStops. Then I either group them by LoadID only if it's to report from that side, or by CustomerID if it's from the invoicing side. The Load reports don't look at what customer...

Exactly! I just figured that criteria out today and that is when I got stuck and decided I needed some ideas. This project has been down 4 dead end paths so far so I'm not looking at it very clearly. Should step back for a day and regroup but I just need to be done! Lol. I was trying to decide...

Except for the trucks. They are owned by this company not the trucking company. They're a separate entity all together. A load can only be hauled by one truck. The tblTrucks gets updated with the new miles added on and that's reported on when they need serviced or something is expiring on them...

This is the copy I've been playing with so pay no mind to some of my "experiments", but you'll get where I'm trying to go. The data entry of the loads and the invoicing are the sole purpose of the Db. One is looked at from the load side, the other by the customer side. they aren't a very large...

Almost, trucks have nothing to do with trucking company, only drivers do. A trucking company has many drivers. A date can have many loads. A load can only have 1 truck, date, driver, trucking company, perPoundRate, Miles and Cost. A load has multiple stops. A stop can have multiple customers. A...

The cut off one is tblTrucks if you can't tell.

I don't like the way the drivers and trucking companies are set up but couldn't really figure out another way to be able to look up a driver by their Company and by the Load.

I thought I had a direction I was going then yet another criteria arose and I'm just having a hard time picturing it. I've also just been staring at it for too long. In the attached pic is what I had but now there can be more than 1 customer per stop so the subform on the right won't work. The...

The data type in the table is Currency.

Well that seems to have done it! Thank you. It probably would help if my dummy data was a little more realistic, and honestly my python faker scripts usually hit it right on the mark but I guess truck driving just isn't a learned type yet. Lol.

This is what I got using the Module.....*ugh

Yeah, that did no good at all. Still the same results.